1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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

submitted by /u/NickelbacksNo1Fan
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel
#Data Entry
#Time
#Shortcut
#Formatting
#12-hour format
#24-hour format
#Time Entry
#AM/PM
#Colon
#Formula
#Cell Formatting
#Four Digits
#Administration
#Automatic Recognition
#Faster Method
#Mine
#Numeric Input
#Time Conversion
Seeking Excel shortcut for entering times without typing the colon