Hi all

I need to ascertain when a given action needs to be completed by, by
adding a SLA (service level agreement) to the current date and time.

Note:
- SLAs may be anything from 1 minute to 2 weeks
- Weekends must be ignored (not included in calcs)
- A work day is Monday to Friday 6.30AM to 7.00PM

So, for example, if it's Friday 4PM and a SLA is 4 hours, the required
completion time should be Monday 7.30AM.

I've looked at Chip Pearson's site for date/time calculation, but my
problem does not appear to be addressed. Any direction is much
appreciated.

Paul Martin
Melbourne, Australia