Time duration to numerical number of minutes.

[FredM400]

Greetings

I am sure this is a case of my brain melting in the heat, but what is the best way to convert a duration expressed in HH:MM:SS to a numerical number of minutes that can be in a math formula.

Example:

Cell A1 contains the time duration of 1:45:30

I want cell A2 to contain the numerical value of 105.5

Thanks!

 

[T. Valko]

Greetings

I am sure this is a case of my brain melting in the heat, but what is the best way to convert a duration expressed in HH:MM:SS to a numerical number of minutes that can be in a math formula.

Example:

Cell A1 contains the time duration of 1:45:30

I want cell A2 to contain the numerical value of 105.5

Thanks!

Multiply by 1440 and format as General or Number.

=A1*1440