I want to create a database for the recording the time employees spend on certain tasks and then total it and come up with some statistics about the productivity. I like to know if the data can be entered in minutes and hours but stored in decimal so that it can be used for calculations. Example: 2 hours 30 minutes => 2.5 hours
Results 1 to 2 of 2
Thread: Time issue (2000)
-
New Lounger
- Join Date
- Mar 2002
- Posts
- 2
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-05-17 13:27Time issue (2000)
-
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
2004-05-17 13:43Re: Time issue (2000)
If you define a date/time field, times are actually stored as numbers representing the fraction of a day; one day is the basic unit for all date and time calculations in Windows. You can perform calculations on date/time fields as if they are numbers, if you take thus into account. So 2.5 hours must be used as 2.5/24 since there are 24 hours in a day.
