ok, i modified my formula to correctly catch instances where the planne
might be before midnight and the actual might be after using
=IF(AND(P50.791666,Q5<0.1875),(Q5-P5+1)+(R5-S5),(Q5-P5)+(R5-S5))
the 0.791666 is equivalent to 19:00 and the 0.1875 is 04:30, basicall
if planned start is after 7pm, and actual start is before 4.30am the
add 24 hours to the result, else both planned and actual are eithe
before or after midnight and so calculate normally. This seems to b
catching all instances of it.
I wont bother with the negative time for now
Thank
--
Message posted from
http://www.ExcelForum.com