I have a spreadsheet to calculate time worked in a week.
The daily times are added together.
Then an amount of 45 hours should be deducted from the weekly time to calculate the overtime.
I get the weekly total time (R8), but cannot create the formula to subtract 45 hours from R8 in U8.
Put differently: How do I write a formula in U8 that gives me the total time in R8 minus 45 hours?
Picture below and worksheet attached.