HH:MM when sum is greater than 24

**SparkBigDreams** · 04-28-2017, 01:05 PM

Okay, Excel is supposed to automatically format into HH:MM when adding times so long as that is the format you have the cell set to. But it isn't!!

Should be a Word attachment with a screenshot..

**JohnTopley** · 04-28-2017, 01:08 PM

For values greater than 24 format as:

[h]:mm

**MrShorty** · 04-28-2017, 01:09 PM

Hard to say much from a picture in a word document.

number format codes: https://support.office.com/en-us/art...fab54be7f4#bm1

You claim that you are having trouble with the hh:mm format code. hh:mm formats for "time of day", but it sounds like what you really want is [hh]:mm. the brackets tell Excel that you are looking for "elapsed time" rather than "time of day".