Interval days hh:mm excluding weekend days

[#1]

Hello,

I have a small issue, I want to calculate the interval between 2 dates but I don't want to calculate the weekend days. And the result should be in DD HH:MM.

In the chart.jpg, I'm using the Interval() method. But is taking the weekend days.

I found out about NetWorkDays(), but it calculates me only the days, I want the hours and minutes too.

Can you tell me if there is any possibility to do this ?

Thanks you!

Best regards,

Claudiu

[swuehl]

This would only work when you in fact have timestamps, not dates.

Maybe something like this (maybe this is too complex, considering also working hours per day)

Calculate hours between two Date/Time strings

[#3]

Thank you! It is useful !