J
JoeP
I have cells in an Excel 2003 spreadsheet with the format h:mm:ss. When I
want to enter a time that is before 1:00:00 I need to enter in the leading
zero like this...
0:30:15. If I don't include the leading zero my formulas don't work properly.
My question is - is there any way to format the time so that I do not need
to include the leading zero when appropriate.
Thanks for any help.
want to enter a time that is before 1:00:00 I need to enter in the leading
zero like this...
0:30:15. If I don't include the leading zero my formulas don't work properly.
My question is - is there any way to format the time so that I do not need
to include the leading zero when appropriate.
Thanks for any help.