Brad -

I would suggest using decimal hours for this. See your other posting...

--
Daryl S


"brad" wrote:

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?