SOLVED

excel formula

Copper Contributor

Hello, i have problem to search the right excel formula. I need formula to to count overtime payment. So, if the total work hours employee on one month bigger than 200 hours, that count overtime work. If under 200 hours, the employee dont have overtime.

 

I think the formula is IF, but i dont know how the right formula to count time if have overtime. 

Thankyou for helping me 

2 Replies
best response confirmed by Ami3000 (Copper Contributor)
Solution

@Ami3000 Something like this perhaps?

Riny_van_Eekelen_0-1717393425935.png

 

great thankyou
1 best response

Accepted Solutions
best response confirmed by Ami3000 (Copper Contributor)
Solution

@Ami3000 Something like this perhaps?

Riny_van_Eekelen_0-1717393425935.png

 

View solution in original post