Finding time differences in access

[ccs2]

I want to use the DateDiff function to work out the time interval between a start time (e.g.10am) and an end time (e.g. 10.35) in a race.
Can anyone help?

 

[HandsOnAccess]

You can use "n" to calculate time difference in minutes when using DateDiff function. Example is shown below

Public Function calculate_time_difference()
starttime = #10:00:00 AM#
endtime = #10:35:00 AM#
MsgBox starttime & Chr(13) & endtime & Chr(13) & DateDiff("n", starttime, endtime)
End Function

 

[PHV]

You may also consider this:
MsgBox Format(endtime - starttime, "h:nn")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[ccs2]

I seem to have cracked this by setting up a SwimTotal field in the Selection table with a Data Type, Number/Long Integer. Then I set up an Update query as follows:

Field: SwimTotal
Table: tblSlection
Update to: DateDiff("s",[SwimStart],[SwimEnd])

This calculates the time in seconds (s). You will then have to divide this by 60 in an expression which you can put in a query if you wish, or on the form or in a report later (maybe all three). In a Triathlon you will need to do this for each race and then use an expression to add the three totals together in an Overall total field. Looks like fun!