Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    convert time to number (AccessXP)

    I have a schedule with starting and ending times, done in medium format. I need to figure number of minutes, i.e. 1 hour and 30 minutes equals 90 minutes. I will need to then divide the total minutes by 50 to figure the number of contact hours. Nothing I have tried allows me to convert the hours and minutes to a regular number (with the corred values). Any ideas?

    Thanks!
    Fay

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

    Re: convert time to number (AccessXP)

    Times are stored as numbers, with days as unit. To convert a time to minutes, multiply by the number of minutes in a day: 24*60 = 1440.

Posting Permissions

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