Time Difference?

[Static]

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

[RhinoBull]

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

[Static]

d*mn! thats what I forgot...
add the date into the datediff!

DUH!

Thanks man!

[RhinoBull]

Any time.