time between two records



I will try to make this simple and clear.

I want to calculate the time between two records

ID1: TestTime1 10:00 AM, TestTime2 10:10 AM
ID2: TestTime1 10:11 AM, TestTime2 10:21 AM

I can tell by looking that there is 1 minute elapsed time between ID1
TestTime2 and ID2 TestTime1

I then want a report to show ID1: ElapsedTestTime
then next Record on the report I would like to show Elapsed TestTime and
ElapsedBetweenTestTime (Time between 1st Record TestTime2 and 2nd Record

Thanks in advance

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