time format

  • Thread starter Thread starter JoeP
  • Start date Start date
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.
 
No, because if you enter 30:15 then Excel will take this to mean 30
hours and 15 minutes, and will probably display it as 6:15:00 in the
cell, but the formula bar will show 01/01/00 06:15:00.

An alternative which might be a bit simpler for you to type is to
enter that time as:

30:15.0

Maybe ".0" added on to the end is easier than "0:" added on to the
beginning.

Hope this helps.

Pete
 
Back
Top