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
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