I have been tasked to calculate due dates from a list of dates, from a call log date/time. This would be base on a start time of 8:00am and end time of 5:30pm which makes a total working hours of 9.5 hours Monday to Friday, excluding weekends. I have tried calculating this however it breaks whenever a call come in at midnight on a weekend, it doesn't go to the next working day.
please see attached
Bookmarks