Can you Enter Time quickly?

[Justin Yi-Riley]

hello everyone, I tried researching this first but could not find something that was exactly like my problem.

I’m trying to find out if it’s possible to enter time without the colon and without typing A.M./AM and P.M./PM but shortening it to just “a” for AM and “p” for PM. I currently use an online time sheet by my employer where I can type “830a” and is converted to “8:30 AM” and “445p” as 4:45pm etc.

I don’t want 24 hr time and I still want the cells to show “8:30 AM” I just want to be able to type “8 3 0 a” and have it turn into 8:30 AM.

I tried messing with the auto complete, messing with custom time formats but nothing worked. Any ideas?

Thanks!

 

[GraH - Guido]

If you want to invest some of your time to enter all possibilities in the dictionary, then you can do it like this:


When typing in a cell 8 3 0 a, it gets replaced by 8:30 AM


and... format is hours.

 

[NARAYANK991]

Hi ,

Why do you want to spend so much time looking for ways to convert in the same cell where you enter data ? Can you not convert entered data into the format you want using a formula in another column ?

Instead of using spaces and a and p everywhere , use a 24 hour format to enter data ; entering 830 would be converted to 8:30 AM , while entering 1630 would result in 4:30 PM.

Narayan

 

[GraH - Guido]

Hi Narayan, that is the wiser option indeed. Before you start thinking I have some screws loose, I genuinely thought the craziness of the proposed idea was explicit enough (seems not). "All possibilities"... Come on, so cumbersome, but still a way.
Should have added something like: "You really want to do that?"