Time between 2 dates minus weekends

[system]

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+
ToNumber(FormatDate([End Time];"ss")))
-(ToNumber(FormatDate([Start Time];"HH"))*3600 +
ToNumber(Left(FormatDate([Start Time];"mm:ss");2))*60+
ToNumber(FormatDate([Start Time];"ss")))

Anyone?, Thx

---

Lucq (BOB member since 2008-07-17)

[system]

Try looking at this thread:

120×120 10.4 KB

How do I calculate number of working days in a month? If an employee works for 5 days in a week, how many days he will be working in a month? Similarly, if he works for 6 days in a week, how many days he will be working in a month? Similarly, if he works for 7 days in a week, how many days he will be working in a month? So far I am able to calculate 7 working days <7 Working Days> =DaysBetween(<Month> ,<Last Day of month>)+1 kool (BOB member since 2005-04-15)

---

APB (BOB member since 2006-12-04)