time format

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.
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top