Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating a future date using system clock & time remaining
Hi Guys,
I was wondering if anybody knew how to calculate a future date using the system date and time, and an existing "time remaining" variable that I have already calculated? So for example: I have worked out time remaining on a project based on a 'percentage complete' user input. I now want to show the user that his project should be completed on such and such a date (using the system date) Can this be done for times as well? e.g. Project A is 4 day project. It is currently 47% complete. The current date & time is [MM/DD/YYYY & HH:MM:SS] what date & time will the project be complete? thanks a million Kind Regards, Steve Chalom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating a future date using system clock & time remaining
If A2 is length of project in days (or a suitable date/time format) and
percentage complete is in A3 Since remaining amount of time is: =(100%-A3)*A2 the complete formula is: =(100%-A3)*A2+NOW() -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Steve Chalom" wrote: Hi Guys, I was wondering if anybody knew how to calculate a future date using the system date and time, and an existing "time remaining" variable that I have already calculated? So for example: I have worked out time remaining on a project based on a 'percentage complete' user input. I now want to show the user that his project should be completed on such and such a date (using the system date) Can this be done for times as well? e.g. Project A is 4 day project. It is currently 47% complete. The current date & time is [MM/DD/YYYY & HH:MM:SS] what date & time will the project be complete? thanks a million Kind Regards, Steve Chalom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with calculating date 6 months into the future | Excel Worksheet Functions | |||
Calculating a future date | Excel Discussion (Misc queries) | |||
Calculating a Date for the Future | Excel Worksheet Functions | |||
Calculating Clock start time in Excel | Excel Discussion (Misc queries) | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |