How can I figure out the difference between 2 times...
even taking in to account if time A is the day or 2 days before?
7/1/2004 4:50:38 PM
7/2/2004 10:02:22 AM
??
thanks
Printable View
How can I figure out the difference between 2 times...
even taking in to account if time A is the day or 2 days before?
7/1/2004 4:50:38 PM
7/2/2004 10:02:22 AM
??
thanks
VB Code:
Private Sub Command1_Click() Dim sTime1$, sTime2$ sTime1 = "7/1/2004 4:50:38 PM" sTime2 = "7/2/2004 10:02:22 AM" Debug.Print DateDiff("d", sTime1, sTime2) 'days Debug.Print DateDiff("n", sTime1, sTime2) 'minutes End Sub
d*mn! thats what I forgot...
add the date into the datediff!
DUH!
Thanks man!
Any time.