View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default 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