Conversion of time

[merrellpa]

I have a Cell that calculates the difference between 2 times. It works great, and displays the results in a HH:MM:SS format.

I need to take that and convert the time to minutes only...

A3 = The result from above (Example: 3:23:45)
B3 = a set time (10 hours)

My formula is:

(A3 converted to minutes)/((B3*60)-90)*10


If i can convert A3 to minutes this calculation will work cause it is a whole number. Anyone have any idea how to do this?

 

[PA HS Teacher]

Regardless of the number format used to store a time, Excel stores this a decimal fraction of a day. E.g. 0.25 = 6 hours = 360 minutes.

How about something:
=A3*(24*60)

 

[mikerickson]

The formula
=TEXT(A3,"[m]")+0 will return the number of minutes in the time in A3.

Or you could use =A3 and format the cell [h] to keep everything in Excel serial time.