Forum Discussion
Help Please
Hi, I'm trying to create a visual display of an agenda. I really want basically a Gantt chart, but instead of dates, I want it in times. It's a sum of 3 days that I want to display, starting for 8:00 AM to 8:00 PM, but for the life of me, I can't figure out how to calculate duration with times, and every formula I enter shows as an error. Does anyone have any idea how I can do this?
3 Replies
Not sure about what you mean by "the sum of 3 days to display", but have a look at the attached workbook. It displays three tasks on an axis (8 AM to 8 PM). The yellow cells contain the chart data. The gray cells at the top ar just for information. I used them to "calculate" the min and max value for the horizontal axis. Perhaps this helps you find a solution for your problem.
Have a look.
Hi Patrick. Thanks for that, but I honestly don't know how you did that. Is it labeled as "time"? and then did you create 2 series of start and end time? when I did it it just wouldn't display it properly and I also couldn't get the axis to match my entered times.
also, is there no way of doing it by "duration", as in calculating the actual time of the task?
Thanks!
Stav.
