B
bollard
Hello
I want to find out whether an e-mail was replied to within a 3-hour Service
Level Agreement. This involves subtracting one date and time from another.
However, if an e-mail arrives after 4 p.m, as we close at 6 p.m., only 2
hours of that SLA are used up. This gives the team a further hour from 8 a.m.
next morning, to reply within SLA.
In other words, with the working day being 8 a.m. to 6 p.m., what formula
can I use to calculate if a reply is within SLA,i gnoring the hours when we
are closed?
I have the incoming date and time in Column D; the outgoing date and time in
Column E in format: 21/05/2008 18:15 (i.e. UK date format.)
Thanks.
I want to find out whether an e-mail was replied to within a 3-hour Service
Level Agreement. This involves subtracting one date and time from another.
However, if an e-mail arrives after 4 p.m, as we close at 6 p.m., only 2
hours of that SLA are used up. This gives the team a further hour from 8 a.m.
next morning, to reply within SLA.
In other words, with the working day being 8 a.m. to 6 p.m., what formula
can I use to calculate if a reply is within SLA,i gnoring the hours when we
are closed?
I have the incoming date and time in Column D; the outgoing date and time in
Column E in format: 21/05/2008 18:15 (i.e. UK date format.)
Thanks.