Calculating Difference between Times

[kkulick]

I am creating a database that logs all the internet usage in the company. One field shows the time that the people are on each site. I need to perform a calculation that will take earliest time and the latest time and then tell me how long they were on. I need this because people can be on several different sites in one second, so a person could be on for only a couple of minutes but there could be 50 pages of data. All I need to know is how long they are on. Please send suggestions.

 

[andyh]

assuming that you have both fields formatted to date/time you can just use the fomula:

[Field1]-[Field2]

this will return the difference in the 2 times.

If there are several log on / log off times per person, you need to make serveral calulations (one per log on) and then sum all the times

 

[kkulick]

The problem is that the times are all in one field. So I can't use [Field1]-[Field2]. Is there a way to do this in one field?

 

[andyh]

send me a copy of the dbf and I will have a quick look... I can't picture what you are saying...

andy.hartley@valeo.com

 

[Jay/UK]

Dear Andy Hartley,

I noticed your helpful reply to this individual, and wonder if you can assist me too - I have a similar query.

I will be posting a similar query under the heading "Getting Access to auto insert a data in a report". Can you assist me?

Kind Regards,
Jay/UK