Jose,

I am not sure I understand your example.

What is Start and End timr for normal hours?

Regards,
Per

On 11 Jul., 05:06, jose123 wrote:
I need to calculate overtime but due to the start/end times overtime may be
posted at 2 different rates. *How do I calculate overtime for the following:

Start 21:00 * * * * * * * * 2 hours of overtime
End * *7:00 * * * * * * * * 1 hour of overtime for Rate 1 (hours 6:00 - 18:00)
Hours *10.00 * * * * * * *1 hour of overtime for Rate 2 (hours 18:00 - 6:00)

I track the hours worked at both rates so I know 1 hour was worked during
Rate 1 and 9 hours worked during Rate 2.

These same rules would apply if a person worked:
Start * 8:00 * * * * * * * *3 hours of overtime
End * *19:00 * * * * * * * 2 hours of overtime for Rate 1 (hours 6:00 - 18:00)
Hours 11.00 * * * * * * * 1 hour of overtime for Rate 2 (hours 18:00 - 6:00)

Ten hours were worked during Rate 1 and 1 hour worked during Rate 2.
--
Jose