Working days for a date range avoid week ends

[system]

Hi,

Same question was asked yesterday here:

120×120 10.4 KB

Hi, I have a little problem how to throw out weekends from time created between two dates. I’m using 2 dates objects ([start time] , [end time]). I want to create condition that check if is weekend between start and end date total time will be reduced by (saturday and sunday =172800 seconds) I used this formula to change date for time in seconds: =DaysBetween([Start Time];[End Time])*86400 + (ToNumber(FormatDate([End Time];"HH"))*3600 + ToNumber(Left(FormatDate([End Time];"mm:ss");2))*60+ To…

---

Marek Chladny (BOB member since 2003-11-27)