I have two fields, columns A and B
Both are datetime
A contains date / time a call is logged. B contains the time the call was resolved.
For SLA checking, I need to know how many hours difference there is between them, quite simple so far.
The problem is, the calculation needs to take into account the working day. i.e. 9-5 for example.
So, if a call is logged at 4pm then there is only 1 hour of the SLA time used for the current day and the clock so to speak carrys on again from 9am the next day. Meaning the engineer has until 11am the following day. Thats what I need to show.
Anyone able to help?