Posted to microsoft.public.excel.misc
|
|
Timeline using military time
Use HH and delete AM & PM
"Jon Peltier" wrote:
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
|