just format the cell which consist the total with the below mentioned format.

Now your cell will have the formatting as h:mm
Place the cursor which consist the total of the time values Do Right
ClickFormat CellsNumberCustom and apply the below format.

[h]:mm

Change it from h:mm to [h]:mm.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"it''''''''sh hardy" wrote:

Hello! -
I have an excel sheet that is totalling for hours worked, but if someone
works over 24 hours, the total starts over from 0 hour then again up to 24.
How do I format this cell to properly equate what the total hours worked is?

1:35
10:10
0:17
0:52
2:18
5:23
3:36
3:14
0:21
1:57




Total 5:43