1. ## 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. ## 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. ## 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
•