Calculating a future date using system clock & time remaining

[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

 

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