Forum Discussion

BrettTelford's avatar
BrettTelford
Qrew Member
10 years ago

Calculate duration excluding weekends, dependent fields are date/time formatted, present result in hours.

Here is the formula that I have now, that works, that is not excluding weekend days: ToHours(If([Task Status]="Completed",[Deadline]-[Time Completed],[Deadline]-Now())) Here is what I tried t...
Forms
Formulas and functions
Relationships
XavierFan's avatar
XavierFan
Qrew Cadet
10 years ago
The WeekdaySub function uses Date fields - so if you want to use that, you will end up with a result rounded to the nearest day (meaning, the result is no longer "to the hour").

If you want to keep the result in hours - then you have to account for more cases - what happens if the [Deadline] or [Time Completed] falls on a weekend?  How would you convert the "days" result from "WeekdaySub" to hours?  (count each day as 8 hours?  or 24 hours?)  How the to account for the "hours" based on the time?  Gets complicated.

In my opinion, probably more straightforward to keep it to "days" - if possible for your use case.