Timeline using 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

Timeline using military time
 

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

Timeline using military time
 

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

Timeline using military time
 

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

Timeline using military time
 

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

Timeline using military time
 

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

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

Timeline using military time
 

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" <Rookie1stClass@SpamThis wrote in message
...
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