Gant chart / Conditional Formating
Posted by kevin on January 21, 2002 2:00 AM
I read an article where conditional formating was used to create a Gant chart. I wish to do something similar but using time instead of date.
I have a sheet where I list vehicle registrations down the left with Start Time and Finish time. The headers across the top are hourly segments starting at 00:01 through to 23:29.
However the formating does not appear to work if a start is say 22:00 through to 07:00.
Additionally I would like to include other critera such as break time which would again be a start, end time.
Can any one help please