ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculating Clock start time in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/43327-calculating-clock-start-time-excel.html)

Hani Muhtadi

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


JE McGimpsey

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?



All times are GMT +1. The time now is 11:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com