Time format as hh:mm:ss

[Dennis]

When inputing time as above, Excel is thinking it is a Time as AM or PM, but
actually it is a lapsed time. How do I get it to do just hh:mm:ss? Without
placing in the : each time would be a timesaver as well.

Regards,

 

[Niek Otten]

Hi Dennis,

Choose another date format from the Format>Cells>Number tab>Time list.
If there isn't any without AM/PM, use a Custom format and format as hh:mm:ss
(or choose other time settings in Windows International)

Actually Excel doesn't know the difference between elapsed time and a point
in time. Technically there is no difference; a point in time is decribed by
the time passed since some starting point. But that is not easily recognised
in the AM/PM format.

 

[Shane Devenshire]

You may also want to consider the custom format below if there are more than
24 hours:

[h]:mm:ss