I am looking for a formula to sum if either of 2 checkboxes are true to subtract several columns for a total. What I need to achieve is if a box is checked it will basically think it's either an 8-hour workday or a 10-hour workday. Hopefully, the formula below explains better what I am after:
Within Cell F28:
A bit of context behind what I am trying to achieve. A technician has 5 potential jobs in a day. Each job could take a different amount of time. Some weeks are 8-hour days and some are 10-hour days. I need to be able to add in the amount of time each job takes (in the G cells), then depending on what cell is check-marked (E1 or G1), return how many hours are left to block out for the tech.
Please Login or Register to view this content.
I am sharing the link so hopefully, it can be understood a bit better.
I apologize if I am posting this on the wrong board. I could not find a specific place for a google sheet question. I assume the formulas would be similar.
Thanks in advance!