In the attached workbook, I'm trying to calculate median time duration of jobs. The current formula calculates median time minus weekends based on a 24 hour day. Is it possible to do this based on an eight hour day? Here is the current formula:
Any help is greatly appreciated!HTML Code:
Sick
Bookmarks