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

Right click the cell/rangeFormat CellsSelect Category as 'Custom'. Within
the text box labeled 'Type:' enter the below

[h]:mm


If this post helps click Yes
---------------
Jacob Skaria


"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

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

Format as [h]:mm
The square brackets are significant.
--
David Biddulph

"it''''''''sh hardy" wrote in message
...
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