| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change text (8:30 PM) to military time (20:30) | Excel Discussion (Misc queries) | |||
| How to I convert standard time to Military or 24 hour format? | Excel Discussion (Misc queries) | |||
| Change text to military time | Excel Worksheet Functions | |||
| in excel totaling weekly hours military time | Excel Worksheet Functions | |||
| how do you subtract military time? example 12:00 - 07:00 = 5 hour. | Excel Worksheet Functions | |||
Linear Mode
