Excel for Timelines

[pwrigh1]

I am using excel to derive a simple timeline / gantt chart - b
subtracting a stat date from a finish date to get a task duration an
then letting the chart wizard work its magic. Unfortunately, if th
start and finish dates are the same, there is no duration. Overtypin
"1" in the duration box doesn't seem to work either.

Does anyone have any ideas?

P

 

[Jon Peltier]

According to the rules of subtraction, X - X = 0. What duration do you want
to get when start date and end date coincide?

Here are some Gantt chart examples and links:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343
http://peltiertech.com/Excel/Charts/GanttLinks.html

- Jon