This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 32%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
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?
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.
Hi @Alexander Roe ,
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.
Hi @Alexander Roe ,
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.