Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formats in Excel
I am trying to create a spreadsheet which totals times spent on the phone.
I have formatted the cells as [h]:mm:ss. The problem I have is that if the time I paste in in less than 1 hour then Excel misses of the leading 0 and formats as such :mm:ss. When I try to total the columns, it ignores the cells formated as above. If I manually enter the leading 0, it stays. How do I display a leading zero, or, add one in if the value I paste in doesn't have one. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
can excel be a time clock or stop watch? | New Users to Excel | |||
How do I enter a time in excel so it does not print as 1:00:00 PM | New Users to Excel | |||
Every second time i open Excel, it displays the document recovery pane | Excel Discussion (Misc queries) | |||
time interval calculations in excel | Excel Discussion (Misc queries) |