View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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