Entering dates

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

Guest

I am trying to set up a timetable spreadsheet that will allow users to enter
the time as 4 digits and then Excel converts this automatically to the
correct time: for example 1630 would be 16:30. It would make the data entry
so much quicker than having to enter the colon every time. Can this be done
please?
 

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

Enter time with . but display as : 10
Working with times in military/international format. 2
Entering 24 Hour Clock without entering : 5
Quick way of inputting time? 2
go to fitst column of next row when enter (or other key) is presse 1
Excel Vba to change displayed year automatically. 14
Can I enter a 24 hour time without typing colon? 2
Start, Finish including break time 2

Back
Top