View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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