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?
Results 1 to 2 of 2
Thread: Time Calculation (Access 2003)
-
New Lounger
- Join Date
- Jul 2006
- Posts
- 19
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2006-07-20 01:04Time Calculation (Access 2003)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2006-07-20 03:27Re: 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.
