Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Time issue (2000)

    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

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

    Re: 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.

Posting Permissions

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