FORMULA CONCEPTS

[ness]

I've been trying to find the perfect formula for calculating regular hours on
a time card while at the same time considering CA OT laws. I need a formula
that has the following concept with the restrictive boundaries.

If M-F total hours >= 40 put in Zero
If M_F total hours <40
and if hours clocked in on Saturday >8
and 40 minus M-F total hours are also >8 put in 8
BUT if hours clocked in on Saturday are <8
and 40 minus M-F total hours are also <8 put in saturday hours
ALSO if M-F total hours are <40
but hours clocked in on Saturday>=8 (then we need to put in only what hours
complete the 40 for that saturday; hence OT)
ex. if you work 35 hours M-F, and work 9 hours on saturday; we only count 5
out of those 9 as regular hours and the 4 would be considered OT.

is this possible at all??? all/any help is appreciated!!!

 

[Biff]

Hi!

I love time sheets!

is this possible at all???
Certainly!

If M-F total hours >= 40 put in Zero

If you're calculating for OT shouldn't that be <=40?

Put together a sample file with typical data and put in the the results that
you would expect and send it to me. I'll send it back with the formula(s)
needed to do what you want. I'm at:

xl can help at comcast period net.

Remove the can and replace the obvious.

Biff

 

[RagDyeR]

Not to re-invent the wheel, I have an existing WB created to accept times
keyed in from a timecard and set to calculate gross pay according to
California's existing rules.

If you're interested, send me your address.

For my address, cut out cutout.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

I've been trying to find the perfect formula for calculating regular hours
on
a time card while at the same time considering CA OT laws. I need a formula
that has the following concept with the restrictive boundaries.

If M-F total hours >= 40 put in Zero
If M_F total hours <40
and if hours clocked in on Saturday >8
and 40 minus M-F total hours are also >8 put in 8
BUT if hours clocked in on Saturday are <8
and 40 minus M-F total hours are also <8 put in saturday hours
ALSO if M-F total hours are <40
but hours clocked in on Saturday>=8 (then we need to put in only what hours
complete the 40 for that saturday; hence OT)
ex. if you work 35 hours M-F, and work 9 hours on saturday; we only count 5
out of those 9 as regular hours and the 4 would be considered OT.

is this possible at all??? all/any help is appreciated!!!