lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I want to enter a time in a cell but if I open the file any other time, I want the cell show the current time. Very similar to today() when I open it the file it will show the current date.
ctrl+shift+: display the current time but it wont change after. I am thinking of Now() function, but how can I force now() to display the time only not the date. Or do you have any other suggestion. Thank you very much.
I want to enter a time in a cell but if I open the file any other time, I want the cell show the current time. Very similar to today() when I open it the file it will show the current date.
ctrl+shift+: display the current time but it wont change after. I am thinking of Now() function, but how can I force now() to display the time only not the date. Or do you have any other suggestion. Thank you very much.