<div>
Hope below links helps<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms972833.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms972833.aspx</a>
</div>


Hope below links helps

http://msdn.microsoft.com/en-us/library/ms972833.aspx [http://msdn.microsoft.com/en-us/library/ms972833.aspx]

<div>
<div class="content wysiwyg-content">
I have a Ms access database having these fields<br />
empname - text, starttime - date/time, endtime - date/time, elaptime - text<br />
empname &nbsp; &nbsp;starttime &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;endtime &nbsp; &nbsp; &nbsp; &nbsp;elaptime<br />
Raj &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6:30:36 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;10:45:38 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;4:15:02<br />
Chitra &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 6:20:15 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11:22:59 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5:02:44<br />
Suresh &nbsp; &nbsp; &nbsp; &nbsp; 7:10:25 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;12:15:32 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5:05:07<br />
Chris &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8:19:55 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11:55:58 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3:36:03<br />
<br />
I would like to get the total time of the elaptime colum in gridview using visual studio web developer 2005 express edition.<br />
And the total hours need to be displayed on the footer of the gridview.<br />

</div>
</div>


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.


How to calculate the total time of the column

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.