count the Working hours only 9am to 6pm

Regular Visitor

Hi ,

 

Order DateShip Date
08-11-201911-11-2019
08-11-201911-11-2019
12-06-201916-06-2019
11-10-201818-10-2018
11-10-201818-10-2018

 

i have order date and ship date i need how many hours count between to dates.

Exclude the Saturday and Sunday

count the Working hours only 9am to 6pm

 

Thanks,

Venkatj 

0 Replies