Working hours

[Hani Muhtadi]

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

[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


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
>
>