Learn how to a build a cloud-first strategyRegister Now


How to calculate the total time of the column

Posted on 2009-02-07
Medium Priority
Last Modified: 2013-11-27
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.
Question by:sbhavan_s
LVL 52

Accepted Solution

Gustav Brock earned 1500 total points
ID: 23583223
Looks like a duplicate of this question:


LVL 25

Expert Comment

ID: 23584863

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question