projecting time and date from hours entered
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
"Geoffery" skrev i meddelelsen
...
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
|