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