)What formulas to use (for O/T) on a weekly time sheet that contains multiple
overtime rates:

Ord Time X 7 MON-FRI 8th hr X 1.5 9hr+ X 2
Saturdays - Ord Time X 5 - 6th hr X 1.5 - 7th+ hrs X 2
Sundays - All time X 2
Public Holidays - All times X 3

End column should display total payable hours