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

abhishek_vn — Mon, 26 Jan 2026 16:26:21 GMT

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?

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

edwin — Wed, 10 Mar 2021 18:34:09 GMT

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

topic Re: Working Hours Calculation for different business work hours also excluding weekends and holidays and in QlikView

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

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