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

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

HTH,
Bernie
MS Excel MVP

"Pakenn" wrote in message
...
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