24 hour clock

  • Thread starter Thread starter johnfli
  • Start date Start date
J

johnfli

How do I format a cell for when i type in 1330 it changes to 13:30 on
it's own?
as it stands now, if I format it for the 24 hour clock, when I leave teh
cell, it changes to 0:00
 
You must log in or register to reply here.

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

counting cells within certain time frames - 24 hour clock 4
Time Calculations Help 4
If Statement 6
How do I enter time (12-hour clock) & have it display it? 3
Military time 4
How do I format a cell to calculate overnight Hours? 7
How do I add 24 hours to a date and time value formated cell? 4
time calculation, 24:00 - 16:00 = 8 3

Back
Top