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.
Printable View
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:
See VB-helpfiles for more info...Code: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)
Enjoy!