Question on time calculation 1

[cyoung]

I have a situation where I need to figure out the number of minutes between 2 different times.

I am creating an automation program that will send jobs for production upto a certain time, and the amount of time that a job needs varies based on the quantity in that job.

I do not want any thing sent for production that will take longer to finish than the end time, which is 4:30pm

If the current time is 2:30pm, then there are 120 minutes left for production. How would I programatically figure out the number of minutes between the 2 times?

Thanks!

 

[DrJavaJoe]

Use the datediff function, the n is for minutes.
MsgBox DateDiff("n", "2:30 PM", "3:25 PM&quot


"Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'."

 

[cyoung]

DrJavaJoe,

Thanks for the quick response. Works perfectly!