Over time hours calculation

[afaizan]

Hello Experts,

i need to calculate overtime hours, however, i am facing difficulties.

What i need is the following:

Total Working hours
Total Working days
overtime hours, all days in a week except Friday, if he works more than 9 hours, over 9 hours will be considered overtime.

if labour is working on FRIDAYS, Friday hours will be considered overtime hours as Friday is a holiday. as Fridays are coming on different cells as you change the month. that is the problem.

looking forward the solution and experts advise.

 

[Joe4]

Cross-posted here: overtime hours calculation

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.