and how do we recognise overtime hours?

"Debby_Jo" wrote:

I need a formula that will calculate daily hours worked. If the hours are
more than 5 the formula also needs to subtract thirty minutes for lunch from
the daily total hours. Then the formula needs to multiply the daily total
hours by hourly rate ($10.71) for regular hours as well as overtime hours
($16.07). Can anyone help with this one?