Forum Discussion

rcs43's avatar
rcs43
Copper Contributor
Jun 04, 2020

Converting hrs:min:sec to min only

I am trying to convert 33:41:58 (hr:min:sec) to min only.  Have tried using convert function to no avail, even using suggestion offered by Excel help.

Formulas and Functions

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jun 05, 2020

    rcs43 If the "33:41:58" is a real time reference (for example in A1), custom formatted as [h]:mm:ss you can use:

    =A1*1440

    In case it is a text string, try this:

    =LEFT(A1,2)*60+MID(A1,4,2)+RIGHT(A1,2)/60

     In both cases, format the cell as a number after entering, as it will probably default to "48527:12:00"

Resources