Working hours

[Hani Muhtadi]

Hi,

I have helpdesk inquiries logged in at various times of the day. Sinc
our working hours are from 08:00 to 17:00, I would like to the clock t
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
Han

 

[Roger Govier]

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