Calculation

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.
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Someone knows how to add hyperlinks to hours to schedule an appointment? 0
How to Create an S-Curve from Custom Field? 0
How to use/create code in MS Word to calculate age? 0
MS Project. Real progress of the project, % complete 1
Countdown macro - display settings 2
Amending meeting cancels all future meetings 0
Weighted % Complete calculation 1
How to return a 12 hour time format without the AM in an Access query 2

Top