adding hours minutes and second

Brendan Bartley · July 16th, 2009, 09:14 AM

Hi All
I have a database which has a account number for each department and the duration of time for phone calls. So each department has one account number and several hundred phone records. I need to add the duration field this is in the following format 00:02:02 hours minutes and seconds. I need to group the account number and add the duration

Thanks

gbianchi · July 16th, 2009, 09:18 AM

Is your field a string?

Brendan Bartley · July 16th, 2009, 09:22 AM

The field is formatted as date/time

gbianchi · July 16th, 2009, 09:26 AM

I'm afraid to ask this.. but what "date" are you using for every field?? is always the same???

I think that your best bet is to split the field into 3 new fields (in a temp table) and do the maths over there... you can add time (you have functions for that) but I never try a SUM on a date field...

Brendan Bartley · July 16th, 2009, 09:28 AM

Would it be better to format as a text field and add the time that way

gbianchi · July 16th, 2009, 09:35 AM

no, datetime is a little better. at least you can extract the parts easily...

If you are starting with this project, I think that a number column for each one would be better, or just one column and you store the seconds only (and then do the formating every time you show it...)