VB timing question

P

Pakenn

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 [email protected]
 
B

Bernie Deitrick

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

HTH,
Bernie
MS Excel MVP

Pakenn said:
I am writing a VB macro to determine on a daily basis how long it takes
Click to expand...
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)
 
Top