Re: Timesheet for double time if over 48 on the 7th day
See if this will work for you. It's not dynamic to hadnle if you start having a different pair of days as your 2 days off, but the calculations seem to work.
I changed the last row to calculate the equivalent paid hours. So, takes your regular hours + 1.5 * overtime hours. The Double row now just simply says "Yes" if we need to double the hours for that day. Once we have all the equivalent hours, we can add them up and multiply by the rate.