Results 1 to 3 of 3
  1. #1
    sai_rlaf is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    44

    Convert seconds to HH:MM:SS format


    Hello. I have a create date field and a complete date field. I used a date diff function to find the elasped seconds from the two date and times. I want to have it displayed in a report showing Total # of hours minutes and seconds format HH:MM:SS. The number will excede a whole day at times so that is where I need to most help. ANy help provided is appreciated.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,905
    For what it's worth - it's a start

    60 sec =1 min
    60 min = 1 hr
    24 hr = 1 day

    1 day = 84600 sec
    1 hr = 3600 sec

    Total seconds /84600 = Total days
    Total seconds /3600 = Total Hours

    Just googled

    Try this http://www.access-programmers.co.uk/...ad.php?t=57023

  3. #3
    sai_rlaf is offline Advanced Beginner
    Windows XP Access 2010 32bit
    Join Date
    Jan 2011
    Posts
    44
    That did it! THanks alot!

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

Similar Threads

  1. Replies: 1
    Last Post: 08-07-2011, 07:58 AM
  2. Form opens for only seconds
    By MFS in forum Programming
    Replies: 5
    Last Post: 11-04-2010, 09:33 PM
  3. Automatically close form in 5 seconds
    By alaric01 in forum Forms
    Replies: 4
    Last Post: 09-21-2010, 04:25 AM
  4. Convert date format yyyymmdd for datediff
    By TEN in forum Programming
    Replies: 1
    Last Post: 06-17-2009, 09:35 PM
  5. Replies: 1
    Last Post: 06-11-2009, 05:40 PM

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 - Senior Forums