It would make sense, I guess. I wish I could change the case of the AM/PM in
the formatted time.

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


"Rookie 1st class" <Rookie1stClass@SpamThis wrote in message
...
My bad. Regional formatting uses HH and hh to distinguish 24 or 12 hour
clock.
Lou

"Jon Peltier" wrote:

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