How to calculate the total time of the column

Posted on 2009-02-07
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 48

    Accepted Solution

    Looks like a duplicate of this question:

    LVL 25

    Expert Comment


    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now