Barryj
08-09-2006, 07:34 PM
I have tried to format cells that show the 24 hour clock, so that the time in the cell will actually show 05:00 not 5:00.
The time is on a time sheet and is doing a calculation, so if I put a ' in front of the 05:00 it keeps the 0 but will not calculate.
Is there a way of keeping the zero in the 24 hour format.
The time is on a time sheet and is doing a calculation, so if I put a ' in front of the 05:00 it keeps the 0 but will not calculate.
Is there a way of keeping the zero in the 24 hour format.