Archive of Mr Excel Message Board
Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007
Back to Charting for Excel archive index
Back to archive home
gantt chart trouble!!!!!!!!!!!!!!!!!!!!Posted by espen| on January 21, 2001 9:26 AM
When I have a start time, length, and end time, it allways becomes 24 hours to much. When the start is at 12:00 and length is 1:30, the chart shows it like 12:00 to 13:30 the next day!! How can I skip this 24 hours problem?
I have got the answer, never mind the gantt question above.Posted by ESPEN on January 22, 2001 1:06 AM
I have worked a little with my self, and found out that I never should write +1 in a gantt chart formula, even though it's subtracting hours.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.