Date and time fields adding using ADO with SUM Function

[kavacikli]

How can I do to Date and Time fields adding using ADO with SUM function?

Mytablo:Table1

Myfield:
Name=Times
Tip=Long time

Examples:

Times

12:35:40
21:40:50
03:05:25
18:39:17

SELECT SUM(Times) AS SumTimes FROM TABLE1

if total time > 1 day then Sum function invalid total make

What should I do?

[kavacikli]

I FIND IT

sql="select sum(vakit) as zaman from table1
topla.open sql,conn

Etiket(25).Caption = Val(Left(Topla.Fields("Zaman").Value, 1)) * 24 + Val(Left(Format(Topla.Fields("Zaman"), "hh:mm:ss"), 2)) & Right(Format(Topla.Fields("Zaman"), "hh:mm:ss"), 6)

[kavacikli]

Date and time fields adding using Sum Function with ADO??????????????????????????????????????????????????????????????????????????????????