Military time format

Any suggestions on entering time into a spreadsheet and having it appear in military format?

Hi Glen and welcome to the forum.

You can right click - format cell - time - and then select the 24 hour format. Does that work for you?

Format it as h:mm:ss;@

If I wanted to enter in 8AM, I thought entering in 0800 adn using the format would work. The cell displayy zeros in that format with teh cell contents of 1/8/1900 12:00:00 AM.

Originally Posted by shg

If you want 1pm to appear as 1300, enter it as 13:00 and format as hhmm

You'd actually have to put a space between the numbers and the AM or PM.

Thanks for the help ... looks good.

You can enter 800 and have it appear as 0800 by doing the following...

Format - Special - Location - Portuguese (Portugal) - OK