No, try it. Either HH or hh gives two digit hours, with a leading zero if
needed; Excel doesn't distinguish between hh and HH. If you want to display
AM or PM, put AM/PM into the format. If you leave out AM/PM, you get the 24
hour format. Use [h] or [hh] to skip days but show total hours, greater than
24 if it's more than a day.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Rookie 1st class" <Rookie1stClass@SpamThis wrote in message
...
in date time format
HH = 24 hour clock
hh = AM, PM
Lou

"Teethless mama" wrote:

Enter full date and time: Example 12/5/2006 16:00
then format as military time

" wrote:

I am trying to create a timeline for work that will show a certain task
and how long that took. I need the timeline to go through a couple of
days. My data looks something like this.

Task Start Stop Duration
A 0900 1100 2
B 1100 2100 10
C 2100 2100 24
D 2100 0800 10

I need to use military time and I need the x axis to start on Monday at
0900 and go through a couple of days. Anyone have any suggestions?

Thanks