Hi,
I am trying to calculate when an inquiry comes in to our helpdesk
outside working hours and when it was answered based on the follwing
example.

Example:

Working hours are 08:00 - 17:00 Monday to Friday.

If inquiry comes after 17:00, then the inquiry is attended the next
working day and an answer is guaranteed by the close of following
working day. If the inquiry comes during working hours, again the
garantee is for the answer by close of next working day.

I need to be able to measure how long an inquiry has missed the
promised deadline by.

Can anyone help please?


--
Hani Muhtadi
------------------------------------------------------------------------
Hani Muhtadi's Profile: http://www.excelforum.com/member.php...o&userid=26794
View this thread: http://www.excelforum.com/showthread...hreadid=400924