VB Timing Question

P

Pakenn

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?
 
B

Bob Phillips

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 said:
I am writing a VB macro for how it takes product to flow down a production
Click to expand...
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?
 
R

Rob van Gelder

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

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


Pakenn said:
I am writing a VB macro for how it takes product to flow down a production
Click to expand...
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?
 
Top