adding time on report

[amna77]

Hi, In table I have field, its text field. in that field I am saving time
format: hh:mm:ss like hours minute and seconds. now I want to add the time. how would I do that? is there any example? please help me.
Thanks in advance.

 

[dhookom]

You should really save time durations in a numeric field (or date/time). However if all the values convert well to times, you could use:
=Sum(TimeValue([TextTimeField]))

Duane
MS Access MVP
Find out how to get great answers faq219-2884.