Kelly

  • Thread starter Custom Time Format
  • Start date
C

Custom Time Format

Using Excel XP
I have to enter military time into a cell. To enter
14:06, I want to be able to enter 14 and then 06 without
the colon. Can this be done? I have a lot of data to
enter.

Thank you
 

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

Time In-Time Out/No. of Units 10
Trying to lookup values on another sheet 2
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Using Index and Match Formula 2
Using the IF function 1
Start, Finish including break time 2
Difference between 2 dates&time(format 0000), and excludes weekend 1
Military Time & Colon 3

Top