Forum Discussion
Solved
formula for weekday and overtime
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...
Thank you so so much! i was struggling with this for a long time. Thank you so much for helping me out.
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)
Thank you so so much! i was struggling with this for a long time. Thank you so much for helping me out.
- Hello,
I have got a problem with the formula.
for wednesday it is sunbstrating 20 minutes instead of 8 hrs.
I have tried to remove the dot in the formula and replace it by a comma, then it substracts the 8 hours. However, then for saturday it shows 0:00 hrs even when there is overtime.
Can you please helpOh 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)
- Thank you, really worked well.