• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculating Actual Business Hours Including Network Days

recomi

New Member
Hello everyone.

I am creating a file that will calculate the number of hours it takes to pick an order from the time it prints.
I need to take into consideration, production hours are from 8:00a.m to 5:30p.m. and we do not work any weekends.
I have read some good threads but not specific to what I need. As well I am getting negative hours producing the crindging ###########

Cell V2 is the print time which is formatted yyyy:mm:dd hh:mm:ss
Cell W2 is the pick time which is formatted yyyy:mm:dd hh:mm:ss
Cell Y2 is where the calculated time in actual hours should be.
 
Back
Top