Multiple times and Time durations (1 Viewer)

[mikechp]

I would greatly appreciate any suggestions for coding or sample dbs I could emulate.

I am attempting to create a web log database for a multi-user environment. The text file I have to work with contains fields for USER and TIME and TYPE OF TIME.
Unfortunately, TIME includes starts, ends, and connects.

If there were separate columns for starts, ends and connects, this would be easy. But all the times are in one TIME field.


USER TIME TYPE OF TIME
Mike 11:01 AM Start
Mike 11:04 AM End
Mike 11:15 AM Start
Mike 11:18 AM END
Pat 9:10 AM Start
Pat 9:11 AM Connect
Pat 9:12 AM Connect
Pat 9:20 AM Connect
Shirley 1:00 PM Start
Shirley 1:15 PM Connect
Shirley 1:16 PM Connect
Shirley 1:17 PM Connect
Shirley 1:18 PM Connect
Shirley 1:19 PM End

For each user, I need to be able to report how much time was spent on the internet. MY DIFFICULTY is that each user usually has numerous start, end, and connect times. But I don't know how to calculate time duration with several starts and ends.

FOR EXAMPLE: How can I subtract Shirley's first "Start" TIME from her first "end" time,
Shirley's next start TIME from her next "end" TIME? AND SO ON AND SO ON? And then do the same for each user?

Any suggestions would be greatly appreciated!

 

[Jack Cowley]

This article should give you some insight into how you can calculate Date/Time in Access. Also search help for DateDiff function.

HTH,
Jack

 

[R. Hicks]

What article?..........gotcha

I will now try the "Vulcan Mind Melt" to read Jack's mind.
Try the following link:

http://support.microsoft.com/support/kb/articles/Q130/5/14.asp?LN=EN-US&SD=gn&FR=0

from the depths

[This message has been edited by R. Hicks (edited 09-08-2000).]