How do I calculate using a 8 hour and 40 hour overtime formula? What I am
working on is I have three roll of days off with pay, regular hours and
overtime. We use 40 hour overtime formula for regular hour overtime, but have
to use 8 hour over for days off. Example:
A B C D E F G H I
1 Hour Type Mon Tues Wed Thur Fri Sat Sun Total
2 Days off 0 0 15 10 0 0 10 35
3 Regular 15 15 0 0 18 16 0 64
4 Overtime ? ? ? ? ? ? ?

We have to use 8 hour overtime rules when they work on their days off with
pay any thing over 8 hour is over time. On regular hours any over 40 hours
for week period is overtime. How to use formula for 40 and 8 hour for
overtime?