I need help building a formula that calculates the amount of time between two fields with dates and times in them. I would like it to subtract the hours that are not in the normal 8am-5pm work day.
I have set some service standards and I would like to track how well I am living up to them. I'm recording when the service item is received and then when it is completed, and I have not figured out how to do this calculation automatically.