Help need in re creating the date

vinod22kv — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have data like below. i have to re create the the data and time with the below conductions.

Any ticket that is logged after 5pm Monday – Friday needs to be counted the next day Morning 9am.
Tickets logged on a Saturday after 12 needs to be counted as the following Monday morning 9 am.

Can you please create the nested if conduction in script level? Please .

Thanks and Regards,

Vinod

Re: Help need in re creating the date

Claudiu_Anghelescu — Fri, 31 May 2019 22:32:59 GMT

See my attached work.

I think that it works perfectly for you 🙂