Working Hours Calculation for different business work hours also excluding weekends and holidays and

[abhishek_vn]

Hallo guys,

I'm sorry for bringing this up again after all this years

First of all thank you for your solutions, it works great but I have to manage a slightly different situation.

Working hours are different on fridays. I mean, I have:

7:30 to 16:00 from monday to thursday

7:30 to 14:00 on friday

How do I accomplish the correct calculation giving this issue (Calculate the working hours betweeen 2 days given start and end date)? Is this possible?

[abhishek_vn]

Hallo guys,

I'm sorry for bringing this up again after all this years

First of all thank you for your solutions, it works great but I have to manage a slightly different situation.

Working hours are different on fridays. I mean, I have:

7:30 to 16:00 from monday to thursday

7:30 to 14:00 on friday

How do I accomplish the correct calculation giving this issue (Calculate the working hours betweeen 2 days given start and end date)? Is this possible?

[edwin]

you can determine the day of the week in your calendar using weekday function, you can then associate this to a table with weekday and time start and time end as fields or just total hours per day  

if you share your data model someone would be able to give specific help