Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Working hours
Hi, I have helpdesk inquiries logged in at various times of the day. Since our working hours are from 08:00 to 17:00, I would like to the clock to start the next working day if the inquiry arrives after working hours. Can anyone suggest what formula I should use? Example of cell A1 content: 13/06/2005 14:05 Thanks Hani -- Hani Muhtadi ------------------------------------------------------------------------ Hani Muhtadi's Profile: http://www.excelforum.com/member.php...o&userid=26794 View this thread: http://www.excelforum.com/showthread...hreadid=467220 |
#2
|
|||
|
|||
Hi Hani
Try =IF(TIME(HOUR(A1),MINUTE(A1),0)TIME(17,0,0),DATE( YEAR(A1),MONTH(A1),DAY(A1)+1)+TIME(8,0,0),A1) Regards Roger Govier Hani Muhtadi wrote: Hi, I have helpdesk inquiries logged in at various times of the day. Since our working hours are from 08:00 to 17:00, I would like to the clock to start the next working day if the inquiry arrives after working hours. Can anyone suggest what formula I should use? Example of cell A1 content: 13/06/2005 14:05 Thanks Hani |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Negative Working Hours | Excel Worksheet Functions | |||
Calculating working hours | Excel Worksheet Functions | |||
Calculating working hours | Excel Discussion (Misc queries) | |||
Calculating working hours | Excel Discussion (Misc queries) | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions |