count the Working hours only 9am to 6pm

%3CLINGO-SUB%20id%3D%22lingo-sub-2443856%22%20slang%3D%22en-US%22%3Ecount%20the%20Working%20hours%20only%209am%20to%206pm%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2443856%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22179%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2285%22%3EOrder%20Date%3C%2FTD%3E%3CTD%20width%3D%2294%22%3EShip%20Date%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E08-11-2019%3C%2FTD%3E%3CTD%3E11-11-2019%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E08-11-2019%3C%2FTD%3E%3CTD%3E11-11-2019%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E12-06-2019%3C%2FTD%3E%3CTD%3E16-06-2019%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E11-10-2018%3C%2FTD%3E%3CTD%3E18-10-2018%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E11-10-2018%3C%2FTD%3E%3CTD%3E18-10-2018%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20order%20date%20and%20ship%20date%20i%20need%20how%20many%20hours%20count%20between%20to%20dates.%3C%2FP%3E%3CP%3EExclude%20the%20Saturday%20and%20Sunday%3C%2FP%3E%3CP%3Ecount%20the%20Working%20hours%20only%209am%20to%206pm%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EVenkatj%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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