Please help me to make email tat report .
I have two columns email_receive_time (date time stamp)n and email_replied_time (date time stamp) , I wanted to calculate turn around time between the two during office hours only.
Condition is as follows :-
Office timing is 10 am to 7 pm and all those emails received after 7pm would be considered to be received at next day 10 am and those received before 10 am would be considered to be received at same day 10 am .
Also exclude a single holiday in a month : it can be any random day of a month .