Results 1 to 2 of 2
  1. #1
    Monoceros is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Mar 2009

    Need help with calculating Time total


    I have a report with a column with daily working time (99:00;0;_)for a given month: e.g. 6:15, 7:55, ...

    In the page footer I want the total of the month for that field : e.g. 105:35 (or 105,58 ... it doesn't matter in which format the total is expressed).

    However, when I make the total, it doesn't count over 24 hours.

    How can I fix this ?

  2. #2
    Join Date
    Apr 2009
    I had the same problem. I converted each time to a number of seconds in a query, then used simple math to calculate hours, minutes, and seconds, then string manipulation to display h:mm:ss -- always doing the sums with the seconds total.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Help requested for calculating age
    By techexpressinc in forum Queries
    Replies: 3
    Last Post: 01-28-2009, 11:29 AM
  2. Calculating a sum on a report
    By missourijc in forum Reports
    Replies: 0
    Last Post: 10-30-2008, 07:21 PM
  3. calculating due dates in access
    By trixxnixon in forum Forms
    Replies: 0
    Last Post: 09-28-2008, 12:35 PM
  4. Form calculating troubles
    By Ufalufa in forum Access
    Replies: 0
    Last Post: 11-27-2007, 10:36 PM
  5. Calculating Values
    By Jahan in forum Queries
    Replies: 1
    Last Post: 07-09-2006, 09:15 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums