Then I suggest you write a function that will add times together to give you an overall time. It's not impossible, or particulary difficult, but it takes time to do.
Hint: see HOUR(), SEC() and MINUTE() functions
>hi all,
> i have at mytable field with time as under
>rec1 field tim&&character type
> 10:30:15
>rec2 12:50:05
>rec3 08:10:00
>
>i need to sum this field as
>sum tim to m.k&&to get result 31:30:20
>
>thanks.
>m.qasem
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.