I would like to change the attached spreadsheet so the 'resolve time' cell will calculate a time that will take into consideration a working week and time.

Working Week would be Monday - Friday and working time is 8:30am - 5:30pm.

If anyone could help I'd greatly appreciate it.
Maintenance Example Forum.xls

Thank you