difference between 2 timestamps without weekends, except when enddate is in a weekend

[Quentinn]

Hello,

The goal is to calculate the difference between two timestamp without weekends. The problem; when the enddate is in a weekend, the formula still substracts the full 2 days, instead of calculating the real duration from friday 00:00 till the endtime, and substracting the duration with that time.

See below; the leftmost column is the correct duration, the column next to that one is what I get. 

A solution would be hugely appreciated!

[rwunderlich]

I think when you reference enddate in your expression, you could round off the time if it's a weekend date. Something like:

if(WeekDay(FirstValidatingDateTime) > 4, Floor(FirstValidatingDateTime), FirstValidatingDateTime)

-Rob

[Quentinn]

Many thanks, i'm on the right path now

However, it refuses to round off sundays, even if i specify the beginning weekday

[Quentinn]

i managed to solve that, weekday 0 is sunday and 6 is saturday for some reason, i'll see if i can make my calculations work with your input

[Quentinn · Accepted solution]

I'm almost there!

Now i'm exactly one day short so it has to do with the round in my opinion, any ideas?