Need help with a formula
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)
|