Gannt Chart that deals with dates and times

[slamanager]

Hi all,

ive been doing my home work and have seen the way excel can build "Gannt" charts dynamicly but im stuck now because all the examples have durations in days. http://www.youtube.com/watch?v=CW_wGSFavTc


so my data is as follows
col A task ids (example A-E)
Col B Start dates and times (displayed dd/mm/yyyy hh:mm:ss)
Col C Duration (calc in minutes between D and B)
Col D End dates and times (displayed dd/mm/yyyy hh:mm:ss)

so my data is based on steps taken in a production line A-E theres more than 5 steps this is just an example. how can i control the "scale" so i can see the detail when i compare two production runs. i like the numbers but they would like to see visuals.

 

[jc.021286]

Okay,
In the youtube video, you see the gentleman converting dates to numbers.
You could link the scale to those numbers

You could also try to do away with the date portion. Dates are stored as a number, where the time component is a fraction of a number. Thus, if you removed the Integer.
If I use the Now() function I get
2/24/2011 11:07:46 PM
converted into a number
40598.963725

Thus, If I removed the 40598, I'd be left with only the time. Thus, if you were looking at having comparables between 2 different production lines, this way you can set them both to start at 0, add on Time value, and you ought to have something that will be easily comparable.

Let me know if you need some more on this, or if you are looking for something more in depth,
jc

 

[slamanager]

ok will give that suggestion a try, trying to wrestle with excel 2007 and find the menus I used to love and cherish.

The downside is that the 5 step process can take several days

 

[jc.021286]

Just be sure to subtract your start date as a rounded down integer from your Start date and end date.

or link your scale to the first start date of each, and set the end date equal to the start plus a number that will easily encompass both. ie: if it takes 5 days, select 7 days.

Thus if you size the graphs correctly, they'll be comparable despite having different dates.