Forum Discussion
Kath0427
Sep 14, 2022Copper Contributor
AUTO CALCULATE PAY FOR OVERTIME WITH MULTIPLE CONDITIONS
Hi All, Please i need help with excel formula to calculate overtime pay with multiple conditions. I will be entering the start and end time. Is there a way for the formula to connect to the calen...
NikolinoDE
Sep 14, 2022Platinum Contributor
Here is an example in the attached file.
formula examble: =IF(C2<B2,(((C2+1)-B2)*24)*D2,((C2-B2)*24)*D2)
Hope I could help you with this information / file.
I know I don't know anything (Socrates)