>Hi
> I have a table with 2 fields one is a name, the other is a character type that contains something like this 00:02'23 which mean that this person talked on the phone for 2 minutes and 23 seconds, now I want to know is a sum of how long every person talked on the phone can anybody help
>Thank you
>bill


Convert each pice to seconds:

? (2 * 60) + 23 = 143 seconds

Add up all the seconds, then convert back

? 143/60 = 2 && minutes
? 143%60 = 23 && seconds