hey everybody, wish u a very happy new year.

i'm trying to save the time in hours n minutes to the SQL database table. For this i've a column called "Time_Spent" with datatype "Datetime". But while saving the record,it gives some runtime error.The same problem i face if i've this column with "Timestamp" datatype.
Another problem i face when i need to run a "SUM" query on this column. At present i've declared this column as "float" for convenience. But the "SUM" query obviously returns a wrong result.
Can somebody pls let me know the format in which i should enter the time in hrs. n mins. in the VB6 form?

thnx in advance.