Converting hours to minutes

[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

 

[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
(e-mail address removed)

 

[Guest]

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.

 

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