Time & Gantt Chart Like Display

  • Thread starter Thread starter tcrass
  • Start date Start date
T

tcrass

Alrighty, I think this one could be a bit complicated....but at the sam
time who knows...maybe I'm just making it complicated.

I'm working to compile an excel spreadsheet which produces a gant
chart like display for a schedule based on start and stop times o
employees. I have it working "flawlessly" as long as the time rang
does not overlap the 24:00 mark. I can produce a schedule of star
8:00 and end 17:00 and it will display a "1" for every 1/2 hour betwee
8:00 and 17:00 which allows me to do some interval calculations an
visual relations.

Here's the problem. If I input 20:00 as the start time and then 6:0
as the stop time Excel doesn't display anything because th
calculations of the if statements are based primarily on < or > if
statements and those statements all return false since Exce
'perceives' the start time as being later than the end time.

How do I fix this so it will display 20:00-24:00 "AND" 0:00-6:00?

An example of what I'm visually trying to accomplish is attached. An
help or suggestions would be appreciated
 
Instead of "bumping", try restating your question.

Questions that don't get answered have *very* rarely been overlooked.
Instead, they are usually unanswered because your problem statement was
unclear, or (again, rarely) because no one knows the answer. Often a
restatement works - remember to approach it as if the reader had no
knowledge of your circumstances, because they don't.

Another reason posts get ignored, at least by me and some other
regulars, is if they have attachments - I don't open unsolicited
attachments, partly due to potential virii, and because, usually, posts
with attachments ask the reader to decypher information that the poster
should be making clear in his/her problem statement. Often, the process
of doing so leads to a solution by the poster.

See http://cpearson.com/excel/newposte.htm for tips on using these
newsgroups effectively.
 
Back
Top