Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2006
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Time Calculation (Access 2003)

    I am in need of finding out how to calculate time over 24 hours. Is there a certain formula I need to use either in a query or a report to make this happen?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Time Calculation (Access 2003)

    Unlike Excel, Access has no number format for displaying cumulative time. But it can calculate times over 24 hours without problems. The key to understanding how it works is that dates and times are stored with 1 day (24 hours) as unit. So 6:00 is stored as 0.25 and 15:00 as 0.625. If you multiply a time by 24, you'll get the number of hours, but you must display it as a number, not as a time.

Posting Permissions

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