Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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