Calculating a future date using system clock & time remaining

S

Steve Chalom

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
 
L

Luke M

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()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
separating date and time 5
Re-calculating work for remaining tasks using deadline 0
Date Time decimal value help please 1
How to convert serial date&time to normal date&time? 2
Working with Date/Time 1
Date and Time Conversion 3
Date and Time 1

Top