steve400243
Active Member
- Joined
- Sep 15, 2016
- Messages
- 429
- Office Version
- 365
- 2016
- Platform
- Windows
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.
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.