how can you convert hours into minutes?

[Guest]

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?

 

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

=EndTime - StartTime

Format the cell as

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


--ron

 

[Guest]

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.