How can I get the Display for a Military Time Card to Say 0800 hrs?

[RudeBoy]

Currently I am using this for the Military time as a format for the cell 00\;00
or 00\00 but I want to add hours in there but not mess up the capability for me to sum the hours on the time card.

Is there a way to do this?

Let me know - Thanks for your Heeeeellllllpppppp Take Care.

 

[hiker95]

RudeBoy,

See if the following link will help you:

Categorizing Hours (in military time) from Range -- Please Help!

 

[RudeBoy]

Hmm that seems to still have an issue also. Basically I am displaying right not 08:00 all I want to do is add the letts hrs to the same cell so am looking for a result of 08:00 hrs that's it I am using this in formats as Custom 00\00 so there has to be a way to code up the custom to add 00\00 (hrs) something like that but I just have not found the correct Syntax. For AM/PM we do this AM/PM but that does not work for Military HELPppppppppppppppp Anyone Thanks Take Care

 

[Tetra201]

Maybe

00\:00 \h\r\s\

 

[RudeBoy]

NICEeeeeeeeeeeeeeeee That Works awesome.. I had to change the format to this [hh]:mm but adding your solutions still worked with your suggestion thanks take care [hh]:mm \h\r\s