Aug 06 2021 06:24 AM
hello,
I need help for a formula. I have been struggling with this. Grateful to have some help.
The week starts on Monday. From Monday to Friday the working hours are 8hrs and on Saturdays it is 5 hours.
I need to calculate the overtime based on the total hours per day(th) in cell. The conditions are as follows.
Please help.
Aug 06 2021 06:42 AM
Here is an example:
The formula in C2 is
=MAX(B2-CHOOSE(WEEKDAY(A2),0,8/24,8/24,8/24.8/24,8/24,8/24,5/24),0)
Aug 07 2021 12:54 AM
Solution
Thank you so so much! i was struggling with this for a long time. Thank you so much for helping me out.
Aug 07 2021 01:16 AM
Aug 07 2021 03:58 AM
Oh dear, what a stupid typo. Sorry! It should have been
=MAX(B2-CHOOSE(WEEKDAY(A2),0,8/24,8/24,8/24,8/24,8/24,5/24),0)
Aug 07 2021 12:54 AM
Solution
Thank you so so much! i was struggling with this for a long time. Thank you so much for helping me out.