mikecox39
Active Member
- Joined
- Mar 5, 2014
- Messages
- 251
- Office Version
- 365
- Platform
- Windows
I set the cell format as time and 24 hr. So, when I enter 21:10 the time displays in the cell that way and if I enter 9:10 p the time displays as 21:10, just as expected.
However, when I use the timestamp shortcut (Ctrl+Shift+ the time displays as 9:10 pm.
How do I force the timestamp shortcut to comply with the format I have set for the cell?
However, when I use the timestamp shortcut (Ctrl+Shift+ the time displays as 9:10 pm.
How do I force the timestamp shortcut to comply with the format I have set for the cell?