projecting time and date from hours entered

  • Thread starter Thread starter Geoffery
  • Start date Start date
G

Geoffery

I am using excel 2000 and I have a worksheet I am trying to use for
projecting completion times and dates on projects. I would like to be able to
enter a number of hours in a cell such as A1 and have the worksheet project a
new date in B1 based on todays time and day plus the hours I entered in A1
 
Hi

Enter the time in A1 in the format hh:mm.

In B1 enter this formula:

=Now()+A1

And format B1 as custom "dd-mm-yyyy hh:mm"

Regards,
Per
 
Back
Top