Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to project the due date according to a number of working hours
Does anyone know how to project the due date according to a required number
of working hours? such as If today is 24 Oct, 2005 (Monday) at 9:00am, my project required 100 hours to be finished, then how to create a formula and to project the due date in excel sheet? Working hour: 9am - 1pm and 2pm - 5pm (total 8 working hour per day) Thank for any suggestion Eric |
#2
|
|||
|
|||
How to project the due date according to a number of working hours
See response in excel.misc
-- HTH RP (remove nothere from the email address if mailing direct) "Eric" wrote in message ... Does anyone know how to project the due date according to a required number of working hours? such as If today is 24 Oct, 2005 (Monday) at 9:00am, my project required 100 hours to be finished, then how to create a formula and to project the due date in excel sheet? Working hour: 9am - 1pm and 2pm - 5pm (total 8 working hour per day) Thank for any suggestion Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting number or text to a Date Format | New Users to Excel | |||
Number of labels on X-axis one more than number of values on Y-axi | Charts and Charting in Excel | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
unwanted number to date conversion while pasting data from web | Excel Worksheet Functions | |||
Use Julian Date To Create Serial Number | Excel Discussion (Misc queries) |