View Single Post
  #1  
Old April 22nd, 2010, 05:32 PM posted to microsoft.public.access
Brad
external usenet poster
 
Posts: 943
Default handling elapsed time data

I am trying to import and run calculations on data dealing with total time
logged into a phone system for a group of users. the data is in the following
format:

User Date Total Time
user1 1/1/10 7:45:32
user1 1/2/10 6:31:45
user2 1/1/10 8:05:45

I have found many suggestions for how to calculate elapesd time, but cannot
seem to find how to store/format data already in this format. I am needing to
store the data this way in the table so I can run totals for users/date
ranges. Any suggestions?