Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2010
    Posts
    9

    Unanswered: how to add [hh:mm:ss] values in a query in Access

    How do i sum (add) multple [hh:mm:ss] fields in a query together and if its more than 24hr then it will still show hours ie 25:10:12 this is = 25hr 10min and 12sec
    pls help

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Force an explicit conversion of the Date/Time values to Singles (using CSng()) before performing the additions, then use a user-defined format (or a function) to display the result in the proper format.
    Have a nice day!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •