Faster excel time entry?

Question

question

AlexanderRoe-7496 asked Apr 8, '22 emizhang-msft commented Apr 18, '22

Faster excel time entry?

Is there a way to enter times in excel faster? To enter 8:09 am then 30 minute then 5:34 pm as it is right now i have to enter the cell and move my hand to the number key pad and type 8 then move my hand over to the qwerty keys and type (shift) : then move back over to the number pad and enter 09 then back over to the qwerty and type am. then tap the right arrow and then 30 and repeat, you get the idea.

what i would like is to enter every thing from the number pad. So something like (8.09/01 > 30 > 5.34/02) so the . would be turned in to : and the 01 and 02 would be am and pm.

is there a feature in excel that would let me do that, or a formula that would interpret that string as a time code?

office-excel-itpro

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Viorel-1 · Apr 11 at 02:29 PM

Maybe enter the values with right hand (such as "809/", "30", "534//"), then press a key with left hand like <Ctrl+Q>, which is associated with a VBA macro, made by you. It will convert your input to required format and move the focus to next cell.

Or maybe you can handle the SelectionChange event and adjust the just entered unformatted values.

0 ·

Answer 1 · 2022-04-11T08:17:42.367Z

emizhang-msft answered Apr 11, '22 emizhang-msft commented Apr 18, '22

Hi @AlexanderRoe-7496,
I'm not very clearly about "30 minute" in the thread.
If you only want to enter the values and transform them to TIME format automatically, yo can try this formula:

 =TIMEVALUE(LEFT(A1,FIND(".",A1)-1)&":"&MID(A1,FIND(".",A1)+1,FIND("/",A1)-4)&IF(RIGHT(A1,LEN(A1)-FIND("/",A1))="01"," am",IF(RIGHT(A1,LEN(A1)-FIND("/",A1))="02"," pm","")))

About "30 minute" please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

image.png (12.3 KiB)

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emizhang-msft · Apr 18 at 09:41 AM

Hi @AlexanderRoe-7496,
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

0 ·

question