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"
<clinton.holder.21ng6m_1137283804.7408@excelforu m-nospam.com wrote in
message
news:clinton.holder.21ng6m_1137283804.7408@excelfo rum-nospam.com...

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