Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Availability Table is all wrong... (2003 )

    Hello,

    Please download the attached Help.xls file from the link on this page.

    I need some serious help with this table.

    I've put the assumptions used in the calculations as comment text along with the table.

    Please tell me where I'm going wrong!

    Thanks in Advance for your great help.

    Cheers,

    BobD.

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

    Re: Availability Table is all wrong... (2003 )

    In your previous question, times were in minutes, so you had to divide by the number of minutes in a day, i.e. by 24*60 = 1440.

    In this workbook, times are in hours, so you should not divide by 1440, but by the number of hours in a day, i.e. by 24.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Availability Table is all wrong... (2003 )

    Thanks Hans; your'e a winner.

    Bob.

Posting Permissions

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