Hi Clinton

With the data as posted, there is no way of knowing which day you are
dealing with.
Assuming your data related to 12 Jan 2006, did Jane start at 1:45 am on
the 12th, or the 13th?

I would insert a column at C with the start date, and a column at E with
the end date.
The formula in I1 copied down to I13
=SUMPRODUCT(--($C$14:$C$19<=$G1),
--($D$14:$D$19<$H1),--($E$14:$E$19>=$G1),
--($F$14:$F$19<=$H1))

will then return answers of 4,5,5,5,6,6,6,6,6,6,6,6,6 if she started
work on the 12th and 1 fewer in each case if she started work on the
13th.

--
Regards

Roger Govier


"clinton.holder"
<[email protected]> wrote in
message
news:[email protected]...
>
> Can anyone help with converting the formula above to accomidate the
> calculation for people working past midnight? Currently it just doesnt
> calculate people at all if their shift extends past midnight...
>
>
> --
> clinton.holder
> ------------------------------------------------------------------------
> clinton.holder's Profile:
> http://www.excelforum.com/member.php...o&userid=30427
> View this thread:
> http://www.excelforum.com/showthread...hreadid=500934
>