Forum Discussion

michael_laan's avatar
michael_laan
Frequent Visitor
6 years ago
Solved

Calculating Working Hours Between Business Hour Dates Excluding Weekends

I was have been trying to come up with a calculation for working hours between two dates, exlcuding weekends and non-working hours.  Additionally the calculation needed to adjust the actual start and...
General Comment
Show and Tell
Tips and Tricks
michael_laan's avatar
michael_laan
Frequent Visitor
6 years ago

Thanks, Greg!

I used this edit from your post and it worked perfectly! I did have to make one edit:

Changed:

// Get the start and end dates
VAR __dateStart = MAX([Date_Start])
VAR __dateEnd = MAX([Date_End])

To:

// Get the start and end dates
VAR __dateStart = [Date_Start] 
VAR __dateEnd = [Date_End]

Thanks again, so much cleaner than my work 😉