When calculating minutes; i.e. the difference between two times. For example if you have created Date/Time fields with medium time format. Then you entered 10:00 AM and 12:10 PM, how would you write code that calculates this interval in minutes. To do this you would use the DateDiff function.
If you were to use this in VBA code; an example may look like the following:
Public Sub sTimeInMinutes(Later As Date, NowTime As Date)
Dim TimeIntervalInMinutes As Long
TimeIntervalInMinutes = (DateDiff("n", Later, NowTime))
MsgBox TimeIntervalInMinutes
End Sub
If you wished to work out calculating minutes in a query then using a blank column, in the first row you would type the following:
TimeIntervalInMinutes: (DateDiff("n",[StartTime],[EndTime]))
Where StartTime and EndTime are the names of the fields that contains this information.
Or you may wish to do it on a form or a report. In this case you would add an unbound text box with the following syntax:
= (DateDiff("n",[StartTime],[EndTime]))