Hello,
I'm trying to figure out a formula to automatically calculate response times before we reply to emails we've received.
A1 is the date and time we received the email
B1 is the date and time we responded to the email.
I need the turnaround time to include only hours when we are open and could respond. I'm not concerned about holidays at this point.
From Monday to Friday the hours are 7am to 9pm, from Saturday it's only from 8am to 5pm. Closed on sundays. Keep in mind the start time could be any day, including after hours and sundays, but we would only count the turnaround time from when we next opened.
I've tried searching online for answer, and have found so many different formulas, but none that seem to work in all cases.
Thank you in advance for any help.
Bookmarks