Hello all, I'm not too skilled with excel and these threads are helping a bit but I'm not finding exactly what I need.
Basically, what I want is a formula that I can input the last email date/time that we responded to at the end of the day and based off our business hours it gives us the proper business day turn around.
Our business hours are 7:30am-5:30pm, Monday through Friday, holidays off.
So for example, on May 25th the last email we responded to was for 5/24 5:39pm.
Any help would be GREATLY appreciated
Basically, what I want is a formula that I can input the last email date/time that we responded to at the end of the day and based off our business hours it gives us the proper business day turn around.
Our business hours are 7:30am-5:30pm, Monday through Friday, holidays off.
So for example, on May 25th the last email we responded to was for 5/24 5:39pm.
Any help would be GREATLY appreciated
