I am writing a VB macro to determine on a daily basis how long it takes product to flow down a production line. I can generate the start and end times for each part form a line computer application. Anybody know a method (piece of code) to compute the difference between both times (but taking out the time it takes when the line is stopped. After 4.30pm in the evenings and Saturdays & Sundays)

I know the "NETWORKDAYS" function can take out whole days, but what about the evenings?

Pls reply to