Time calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been working on a database to track our EOD teams missions. Two of my
fields are 'Time Reported' and 'Time Responded'. I have these times set in
the 24hour (Military Time) fromat. I am trying to work a query to give me
the difference in those times, to calculate 'Response Time'. I would like to
then be able to find the average of these times. I have not been successful
in that endeavor as of yet. Any words of wisdom?
 
Use DateDiff() to calculate the difference in minutes:
DateDiff("n", [Time Reported], [Time Responded])

That will need adjusting if some jobs wrap past midnight (unless you include
both the date and time in the fields.)

More info:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Back
Top