Home |
Search |
Today's Posts |
#1
|
|||
|
|||
FORMULA CONCEPTS
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!!! |
#2
|
|||
|
|||
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 "ness" wrote in message ... 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!!! |
#3
|
|||
|
|||
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 ! -------------------------------------------------------------------- "ness" wrote in message ... 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |