Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering dates
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering dates
Chip Pearson has some code that may help you:
http://cpearson.com/excel/DateTimeEntry.htm If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Hoddros wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering DATEs in EXCEL should not require use of "/" slashes. | Excel Discussion (Misc queries) | |||
Automaticaly entering static dates | Excel Discussion (Misc queries) | |||
Entering dates in Excel 2002 | Excel Discussion (Misc queries) | |||
entering and updating dates on a spreadsheet | Excel Worksheet Functions | |||
Entering dates QUICKLY | Excel Discussion (Misc queries) |