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.
 

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

entering time in a spreadsheet 2
Can I enter a 24 hour time without typing colon? 2
List of numbers seperated by a colon 8
How can I insert a colon into a column of existing numbers 5
Time Accuracy 13
Combine multiple cells (3) adding a Colon (:) 4
Entering a mac address in a cell 4
Excel Formula Bar Time Display Format 2

Back
Top