Date and time Format Question

[steve400243]

Hello,
Wondering if anyone knows best way to get the current date and time in a cell with just entering the date. For example if I enter 9/3 in a cell I want the result to be 9/03/2021 10:34am. I have a custom Format set with m/d/yyyy hh:mm But get back just the date, the time comes back as 00:00. Thank you in advance.

 

[JoeMo]

I used the characters instead of naming them, if the semicolons in the post were for grammatical purposes then there wouldn't be spaces in front of them.

Ahhh, thanks for clarifying what should have been obvious to me .