Forum Discussion
AprilIris
May 14, 2023Copper Contributor
Need to type in as military time: 1330 and have it show as military time 13:30
I have seen multiple posts about "converting" from 12 hour clock to 24 hour clock, but my need is different: I automatically time time as, for example 1:30 pm, I would simply type 1330; I need excel ...
HansVogelaar
May 14, 2023MVP
See the second part of Date And Time Entry . Simply format the cells as hh:mm instead of h:mm am/pm.