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.
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.