View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Calculate Work Hours By Day Type

Followers

May 12, 201015 yr

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.