[RESOLVED] Adding time values???

[blakemckenna]

I have a database field that is defined as a "text" field but is stored as a time field "00:00:29", etc.

What I need to do is be able to accumulate this field value and I'm not sure what functions I need to use to do that.

For ex:

00:00:49
00:12:33
00:04:19
01:02:29

I need to be able to accumulate these values and give me the total time.

Thanks,

[Ember]

Dim sumTime as Single
  Dim endTime As Date
  Do Until rs.EOF
    sumTime = sumTime + CDate(rs!timeField)
    rs.moveNext
    ' sumTime is like 0.42345 format keep that without converting back to ##:##:## format
    ' OPS! Problem if sumTime > 24 hours! and converted back above format
  Loop
  endTime = CDate(sumTime)

Strange, but it works!

[blakemckenna]

Thanks Ember, but I figured it out!