HI Folks:
Im about to pull my hair out here
Im running Microsoft Excel for Office 365 MSO (16.0.11126.20234) 32-bit
I am working on a work sheet where I will need to enter a lot of times, but do not have to do any math to them -- its a schedule listing.
The appropriate format for the times are as follows
6:15am = 0615
12:01pm = 1201
3:47pm = 1547
10:21pm = 2221
Midnight = 0000
This is what I know as proper military format, I want to be able to enter it in military format and have it display in military format -- including all leading zeros (I SPECIFICALLY do NOT want to type a colon (
or AM/PM) -- those are very hard to do on the 10key pad
I have tried and tried to re-format the cells -- as far as I can tell from reading the online resources the proper format should be custom with the Type hhmm, however formatting as hhmm and typing 0600 returns a value of 0000 in the cell and 1/25/1900 00 in the formula bar.
This shouldnt be so difficult, but for some reason, I am having a real difficult time with it
Where am I going wrong
Tim