Excel Cell Format for Time

R

Rich48

In order to record a log of events, I want to format a column to display
times as ##:##:## (hh:mm:ss) after I enter the five or six digits without
having to enter the colons. All the time formats I can find are reading the
time from something else. Any help??
 
M

Mark Lincoln

Enter a Custom number format as follows:

00":"00":"00

But note that you can't use this directly in time calculations.
 
Top