Excel Cell Format for Time

G

Guest

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.
 

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

Similar Threads

Shortcut for current Time in hh:mm:ss 2
Base 60 input 7
format time 4
Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss ) 8
Custom Number Formats for Excel 2007 1
Import into excel (Time) 3
MROUND time 2
Working with times in military/international format. 2

Top