Calculate amount of minutes between 2 dates

[Harmough]

Can anyone tell me how to calculate the total amount of minutes between for example:

08-22-00 15:53 and 08-24-00 09:29

Thanks in advance!

Dave.

Use the DateDiff Function:

    Dim Dat1 As Date
    Dim Dat2 As Date
    
    Dat1 = "08-22-00 15:53"
    Dat2 = "08-24-00 09:29"

    MsgBox "Amount of time between " & Dat1 & " and " & Dat2 & " in minutes: " & DateDiff("n", Dat1, Dat2)

See VB-helpfiles for more info...
Enjoy!