Time without a colon

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I enter 24 hour time in a spreadsheet without a colon? It is hard to enter thousands of times into a spreadsheet, if we could have an autoformat that changed a number such as 1345 to 13:45 or 345 to 3:45 automatically
 
Hi
have a look at the following site for an event procedure to do this
http://www.cpearson.com/excel/DateTimeEntry.htm

--
Regards
Frank Kabel
Frankfurt, Germany

Adam said:
How do I enter 24 hour time in a spreadsheet without a colon? It is
Click to expand...
hard to enter thousands of times into a spreadsheet, if we could have
an autoformat that changed a number such as 1345 to 13:45 or 345 to
3:45 automatically.
 
Back
Top