Calculation

  • Thread starter Thread starter GitmoSteve
  • Start date Start date
G

GitmoSteve

I created a table with a Field for "Time of Call" using a Medium Time Format
and a Field for "Time of Return" using a Medium Time Format. I then created
a Field called "Duration". Is there any way that the Duration field can
automatically calculate the time used in the previous two fields. Example:
Time of Call is 13:00 hrs and Time of Return is 14:30 Hrs. This is easy to
calculate in my head as 1 Hour and 30 Minutes, but I want the Duration field
to calculate that automatically and show it for each record.
 
Do not store in the table but display when needed in query, form or report.
You say it 'is easy to calculate in my head' but can you perform the math?
What are the DataType of the fields?
Are any calls from one day to the next? If so, then you should have the
date also.
 
Back
Top