Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
projecting time and date from hours entered
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
projecting time and date from hours entered
=NOW()+A1/24 and format as date,
but of course that will update next time you open the sheet. [I assume that you would have told us if you were looking at some limited number of working hours in a day so I have allowed 24 hours in a day.] -- David Biddulph "Geoffery" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hours between date/Time | Excel Worksheet Functions | |||
HELP PLEASE!! PROJECTING A WEEK ENDING PRODUCTION DATE | Excel Discussion (Misc queries) | |||
excel, automatic date and time when info gets entered | Excel Worksheet Functions | |||
How to get date entered recording first time condition is true? | Excel Discussion (Misc queries) | |||
Auto date/time insert when data entered into an adjacent cell | Excel Worksheet Functions |