how can you convert hours into minutes?

H

Henry

I would like to figure out how long it took to complete a task in minutes
instead of hours. For example
Start time 7:15 AM End Time 9:25 AM. I want to convert instead of 2:10
minutes I want it to be 135 minutes.

Any suggestions?
 
R

Ron Rosenfeld

I would like to figure out how long it took to complete a task in minutes
instead of hours. For example
Start time 7:15 AM End Time 9:25 AM. I want to convert instead of 2:10
minutes I want it to be 135 minutes.

Any suggestions?
Click to expand...

=EndTime - StartTime

Format the cell as

Format/Cells/Number/Custom Type: [m]


--ron
 
B

bpeltzer

If you want the numeric result (rather than adjusting the format as Ron
correctly suggests), you could multiply the result by 1440 (the number of
minutes in a day), and format the results as a normal number.
 
Top