#### AndyTampa

##### Board Regular

- Joined
- Aug 14, 2011

- Messages
- 124

1) The days are 8 hour days from 9:00am to 5:00pm. Work outside those times is excluded from the calculation.

2) We can't count weekends.

3) We can't count company holidays.

The reports have different limits (i.e. 3 business day, 5 business days, etc.). We're looking for a formula that can simply be pasted into the report and edited for the number of days as needed.

As I said, I can't decide on a starting point. Would I calculate the total seconds using networkdays and subtract the exluded times? That sounds reasonable while still complicated. Does anyone have any ideas I can pursue?