Can I get Excel to calculate hours:minutes when sum exceeds 24?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to do calculations involving hours & minutes. Whenever the answer
is more than 24 hours, Excel automatically subtracts 24 from the answer -
27:15 becomes 03:15. I don't want to use decimals instead, so is it possible
to get round this?
Thanks
 
Format cell with custom format: [h]:mm or [hh]:mm
The brackets prevent 24 modulation
The first will show for example 9:25 and 15:25
The second will show 09:25 and 15:25
best wishes
 
Just format the cell with the formula in as:

[h]:mm

This allows times like 27:15 to be displayed.

Hope this helps.

Pete
 
Try a custom format of the resultant cell:

Format/Cells/Custom

and then enter: dd:hh:mm:ss

This assumes you want to show the # of days, hour, minute and seconds
 
Absolutely perfect!! Thank you to all of you.

Larry S said:
Try a custom format of the resultant cell:

Format/Cells/Custom

and then enter: dd:hh:mm:ss

This assumes you want to show the # of days, hour, minute and seconds
Click to expand...
 
Back
Top