Jun 04 2020
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.
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:
In case it is a text string, try this:
In both cases, format the cell as a number after entering, as it will probably default to "48527:12:00"