The fmp5.5 time card template figures overtime as anything over 40 hours
in a week, calculation below:

If(Total Hours ≤ Regular Hours In Work Week,

Round(Regular Hours In Work Week - Total Hours, 2),

""
)

Is there a way for it to calculate anything over eight hours in a single
workday?

Create a new calc field (number result, 7 repetitions), called
DailyOvertime:

case(work hours > 8, work hours - 8)

This will give you your total overtime for each day (a day in each
repetition).

To get total overtime for the week, create another calc field (number
result):
Hours Worked Over Reg + sum(DailyOvertime)


The Wolf wrote:
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California
Associate Member, FileMaker Solutions Alliance

Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> wrote:

Thank you Howard.