[SEMI-URGENT] Making a Bar Graph like Schedule

[tcrass]

First off let me state that this is NOT easy for me to explain so as wa
pointed out so kindly I might need to restate what I was asking. S
here goes...

Background Info:

I'm putting together a spreadsheet which displays "1" or "" based on m
IF statement which is based on the start and stop times of a
employee's work day.

The Formula:

Code
-------------------
=IF(AND(Data!$F35<=F$1,F$1<=Data!$H35,Data!$F35<=F$1+TIMEVALUE("0:30"),F$1+TIMEVALUE("0:30")<=Data!$H35,
Data!$G35<>F$1,Data!$G35+TIMEVALUE("0:30")<>F$1+TIMEVALUE("0:30")),1,""
-------------------


Data Info:

Code
-------------------
F1 is the time of day 0:00-24:00
F35 is the employee start time
H35 is the employee end time
G35 is the employee lunch time (based on a 1 hour lunch
-------------------


The issue:

This works "flawlessly" if I'm going between 0:00 and 24:00 "without
overlapping a day. If I overlap, naturally, this causes a problem.
Anyone know of an easy way to handle this "without" getting into som
serious Macros and things of that sort? For instance, I want to b
able to display a 22:00-6:00 shift if possible.

If you'd like to visualize what I'm talking about please check th
image here: http://www.excelforum.com/attachment.php?s=&postid=58494

 

[Peo Sjoblom]

=MOD(H35-F35,1)

will return 08:00 for start 22:00 and end 06:00

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom