Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Calculating Clock start time in Excel
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time stamp in Excel Sheet | Excel Discussion (Misc queries) | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Help! Excel 2000 fully SP'ed will not start | Excel Discussion (Misc queries) | |||
Unix Time in Excel | Excel Worksheet Functions |