View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steve Chalom[_2_] Steve Chalom[_2_] is offline
external usenet poster
 
Posts: 3
Default 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