Seeking Excel shortcut for entering times without typing the colon
I have a new job in administration at a mine where I have to do a lot of data entry in Excel, and I’m wondering if there’s a shortcut or formatting trick that would let me enter times without having to type the colon every time.
For example, I’d love to be able to type:
1245 → 12:45 PM
0015 → 12:15 AM
OR
1436 → 14:36
0645 → 06:45
Basically, I want to type four digits and have Excel recognize them as a time automatically, either in 12-hour format with AM/PM or 24-hour format.
Is there a way to do this through cell formatting, a formula, or some other shortcut? I’m entering a lot of times, so I’m hoping there’s a faster method than typing the colon every time. I am brand new to administration and I’ve tried fishing the answer online to no avail.
Thanks in advance
[link] [comments]
Want to read more?
Check out the full article on the original site