Converting hours to minutes

D

dragon3s

I have calculated the difference between two time frames and need t
results to be shown in minutes. Instead of getting something like 8
minutes I keep getting 1.25
 
N

Nick Hodge

As soon as you go over 60 minutes, XL converts it to hours. (The same
happens with hours over 24 getting converted to days).

Select data, go to Format>Cells>Custom and type [mm]:ss

This will keep the minutes and not convert to hours

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
J

Jen

I need HELP!.. I am trying to add minutes in a simple spreadsheet. My ending calculation needs to look like hh:mm. I am so lost. I tried the above and it is not working for me. I am adding 17, 80, 20 ,15, 10 and I have tried to divide my 60 (for minutes) and I get 2.37. I need it to be hh:mm. Make sense? Somebody help.
 
D

Dave Peterson

Try:

=SUM(A5:C5)/60

But format the cell as time.
[hh]:mm

will keep the result as hours (not rolling into days)
 
Top