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 |
#2
|
|||
|
|||
One way:
Assume the inquiry date/time is in column A. Then your deadline is B1: =Workday(A1+7/24,1) + 17/24 Format B1 as a date if required. If your actual complete time is in column C, you can subtract B1 from C1 to get hours and minutes elapsed since the deadline. In article , Hani Muhtadi wrote: 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? |
Reply |
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 |