ExcelBanter - how can you convert hours into minutes?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - how can you convert hours into minutes? (https://www.excelbanter.com/excel-worksheet-functions/55602-how-can-you-convert-hours-into-minutes.html)

Henry

how can you convert hours into minutes?

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

how can you convert hours into minutes?

On Tue, 15 Nov 2005 10:37:32 -0800, "Henry"
wrote:

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

bpeltzer

how can you convert hours into minutes?

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.

"Henry" wrote:

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?

All times are GMT +1. The time now is 08:41 AM.