I am writing a VB macro for how it takes product to flow down a production line. Is there an easy method to compute the difference in times taking out the time it takes when the line is stopped. After 4.30pm and Saturdays & Sundays?
Anybody know?

Not sure what you are asking, but in essence, to calculate time, take the
end time from the start time. If it goes over a number of days, you need to
calculate the number of days as well. It is in this bit that you would
discount Sat 4:30pm on.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Pakenn" wrote in message
...
I am writing a VB macro for how it takes product to flow down a production
line. Is there an easy method to compute the difference in times taking out
the time it takes when the line is stopped. After 4.30pm and Saturdays &
Sundays?
Anybody know?

I have an "Hours affected by Dates" example on my website

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Pakenn" wrote in message
...
I am writing a VB macro for how it takes product to flow down a production
line. Is there an easy method to compute the difference in times taking out
the time it takes when the line is stopped. After 4.30pm and Saturdays &
Sundays?
Anybody know?