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

I am trying to import and calculate totals with data from an external source
that shows totals for time logged into a phone system. This show's totals for
each day:

User Date Total Time
user1 1/1/10 12:15:98
user1 1/2/10 4:14:56
user2 1/1/10 10:54:23

I am having trouble getting the table to store this data so I can calculate
totals over date ranges and for each user. I have found pleanty of
suggestions on how to deal with calculating elapsed time, but none for
handling raw data that is already in this format. Any suggestions?