Hello,

We have our security clock-in and clock-out our employees which we use to enter hours for that day, and then total_hours for the week on a timesheet. Currently I use a excel formula to break out Basic, Overtime, and Lunch, but do not know how to program that into the earnings formula in the Salary Structure.

Excel Formula:

((IF(total_hours<=48,total_hours,48))*hour_rate)+((IF((total_hours-48)>=0,total_hours-48,0))*hour_rate*1.5)-((ROUNDDOWN((total_hours/8),0)*hour_rate)

It has three components:

Basic:

((IF(total_hours<=48,total_hours,48))*hour_rate)

Overtime:

((IF((total_hours-48)>=0,total_hours-48,0))*hour_rate*1.5)

Lunch:

((ROUNDDOWN((total_hours/8),0)*hour_rate)

Thanks,

Steve