Calculate Work Hours By Day Type

[Paul Simon]

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.