wasn't figuring anyone was working over 80 hours

--

Gary
Excel 2003


"Lars-Åke Aspelin" wrote in message
...
If the sum of worked hours is e.g. 85, then the overtime is 45 but the
MOD formula only gives 5 so it does not work if the overtime is 40 or
more.

Lars-Åke

On Sun, 3 Aug 2008 19:03:05 -0400, "Gary Keramidas"
<GKeramidasATmsn.com wrote:

not sure, but this may help:

=MOD(SUM(A1:A100),40)