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

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