How to calculate the total time of the column

I have a Ms access database having these fields
empname - text, starttime - date/time, endtime - date/time, elaptime - text
empname    starttime          endtime        elaptime
Raj               6:30:36      10:45:38      4:15:02
Chitra           6:20:15      11:22:59      5:02:44
Suresh         7:10:25      12:15:32      5:05:07
Chris            8:19:55      11:55:58      3:36:03

I would like to get the total time of the elaptime colum in gridview using visual studio web developer 2005 express edition.
And the total hours need to be displayed on the footer of the gridview.
Who is Participating?
Gustav BrockCIOCommented:
Looks like a duplicate of this question:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.