AnsweredAssumed Answered

Calculate Work Hours By Day Type

Question asked by PaulSimon on May 14, 2010
Latest reply on May 20, 2010 by philmodjunk

Title

Calculate Work Hours By Day Type

Post

I'm starting with modifying the Starter Solution Time Card.
I've added more entries to the day types and added a second set of In and Out times to each day.

No problem getting the calculations for work hours to function correctly for this. The only stumbling block I've encountered so far is I want to generate hours worked using two sets of conditions.

Condition 1 calculates work hours based on "day_type" = "Regular"
Condition 2 calculates work hours based on "day_type" ≠ "Regular"

A bonus is calculating overtime as anything over 40 "Regular" hours, which excludes any other type of "day_type" since those don't contribute to overtime pay.

I haven't been able to figure out how to do that, yet.
Any help or guidance would be appreciated.

Thanks.






Outcomes