Dec 21 2022 04:04 AM
I have a short formula in a cell (Col R) that changes the amount of time someone is entitled to depending upon whether they take leave or not. I want to add additional criteria to the initial formula which acknowledges that the time should reduce to 7 hours if 10 hours are taken in Cols N, O, P or Q. I would also like it to reduce to 7 hours if 5 hours are taken (as in half day leave, TOIL, Comp, etc)
Dec 21 2022 04:19 AM
Solution=IF(OR(N34=TIME(10,0,0),O34=TIME(10,0,0),P34=TIME(10,0,0),Q34=TIME(10,0,0),P34=TIME(5,0,0),Q34=TIME(5,0,0)),W34,X34)
You can try an IF(OR( formula.
Dec 21 2022 05:11 AM
Dec 21 2022 05:36 AM
Dec 21 2022 04:19 AM
Solution=IF(OR(N34=TIME(10,0,0),O34=TIME(10,0,0),P34=TIME(10,0,0),Q34=TIME(10,0,0),P34=TIME(5,0,0),Q34=TIME(5,0,0)),W34,X34)
You can try an IF(OR( formula.