VB timing question

[Guest]

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 (e-mail address removed)

 

[Bernie Deitrick]

Post samples of you data, and what time you would expect to calculate from
each.

HTH,
Bernie
MS Excel MVP

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)