Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Time/Weeks (Excel 2003)

    I have a time sheet with total hours for a project. The cell is formatted [h]
    Now I need to calculate how many weeks the project will take.
    There are 7:30 hours in a working day (formatted hh:mm) and 5 days per working week (formatted Number, no decimals).
    Work is estimated at 276 hrs for the project.
    How do I calculate the days for the project using the above details?
    (It is a no-hair day today!) <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>
    Regards

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

    Re: Time/Weeks (Excel 2003)

    Let's say that:
    - total hours is in A1 (formatted as [h])
    - hours per working day is in A2 (formatted as hh:mm)
    The number of working days needed is simply =A1/A2; if you want to round up to the next whole number of days, use =ROUNDUP(A1/A2,0)
    You can compute the number of working weeks by dividing the number of working days by 5, again rounding if necessary.

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Smithfield, Free State, South Africa
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Time/Weeks (Excel 2003)

    Thanks, Hans.
    Regards

Posting Permissions

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