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

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
 
B

Bernard Liengme

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
 
P

Pete_UK

Just format the cell with the formula in as:

[h]:mm

This allows times like 27:15 to be displayed.

Hope this helps.

Pete
 
L

Larry S

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
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sum hours and minutes totalling over 24 hours? 1
Is there a way to make a time cell not reset when it reaches 24? 1
Excel Excel Formula to calculate economy of a bowler (Cricket) 2
Return 24:00 when amount of hours worked equals 24:00 2
Please HELP...nervous wreck time calculation 3
Can I get Excel to call my macro for number formatting? 5
What function do I use to calculate a Sum of Digits? 3
How do I set up a time sheet in Excel? 8

Top