Time calculation using the Shift Details

Summary:Hi, We are looking to create a time calculation to calculate Overtime based off either shift properties or the assignment work schedule.

Example:

Shift A

Start Time 7:30 AM

End Time 4:30 PM

Shift B

Start Time 9:30 AM

End Time 5:30 PM

We have created multiple shifts (like above) that will be assigned to employees on the Assginment Work Schedule.

What we would like to do is calculate based overtime

Calculation:

If a person records time 15 mins (or more) before the start of their shift we want to pay overtime 1.5.

Example Person is on Shift A:

Monday records time 7AM

They would be paid OT 1.5 for 30 mins from 7:00 AM to 7:30 AM