Forum Discussion
Tobysan
Nov 01, 2025Copper Contributor
Excel formula to take time off from a time range
I am trying to get Cell D2 to give me a result based on the result in C2. I have 4 different time "zones" Each time slot has an amount of time taken off so if the employee starts at 7am and finishe...
JohnVergaraD
Nov 05, 2025Copper Contributor
Hi everyone!
Another option could be:
=C2-LOOKUP(C2,{4,6,8,9}/24,{15,30,60,90}/1440)Blessings!