Hi expert

Can somebody help me, on how to perform below formula on column B in excel

ABRemark22-02-2024 14:2722-02-2024 14:27Before 6pm. Same date and time22-02-2024 20:2723-02-2024 09:00After 6pm, from Thursday change to 9am next business day(Friday)23-02-2024 17:0026-02-2024 09:00After 6pm, From Friday change to change to 9am next business day(Monday)24-02-2024 12:0026-02-2024 09:00Within weekend, change to 9am next business day(Monday)

​Hi expert Can somebody help me, on how to perform below formula on column B in excel ABRemark22-02-2024 14:2722-02-2024 14:27Before 6pm. Same date and time22-02-2024 20:2723-02-2024 09:00After 6pm, from Thursday change to 9am next business day(Friday)23-02-2024 17:0026-02-2024 09:00After 6pm, From Friday change to change to 9am next business day(Monday)24-02-2024 12:0026-02-2024 09:00Within weekend, change to 9am next business day(Monday)  Read More

​