Timeline using military time

N

nickandamy

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
 
T

Teethless mama

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

Jon Peltier

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
 
R

Rookie 1st class

My bad. Regional formatting uses HH and hh to distinguish 24 or 12 hour clock.
Lou

Jon Peltier said:
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 said:
in date time format
HH = 24 hour clock
hh = AM, PM
Lou
 
J

Jon Peltier

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 said:
My bad. Regional formatting uses HH and hh to distinguish 24 or 12 hour
clock.
Lou

Jon Peltier said:
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 said:
in date time format
HH = 24 hour clock
hh = AM, PM
Lou

:

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

:

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
 
J

Jon Peltier

That eliminates the AM or PM and reverts to the 24 hour clock. I was talking
about am or pm, not AM or PM.

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


Rookie 1st class said:
Use HH and delete AM & PM

Jon Peltier said:
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 said:
My bad. Regional formatting uses HH and hh to distinguish 24 or 12 hour
clock.
Lou

:

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
_______


in date time format
HH = 24 hour clock
hh = AM, PM
Lou

:

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

:

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top