Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time function =Now formula
Hello,
I don't think it's possible, because I look in all the books and searched the Internet, but here is the function I would like to have. Have a A1 cell with the value =NOW() to apply the current date in time in that cell Have a A2 cell that would display the A1 cell value minus 1 hour Have a A3 cell that would display tha A1 cell value minus 15 hours I basically need to ba able to see the curent hour (13:02) in the A1 cell and see (12:02) in the A2 cell and (22:02) in the A3 cell. Not possible, right ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro / function text time to 24hr excel time passed midnight fortotaling hr's | Excel Worksheet Functions | |||
Insert Function next to formula bar gives Run-time Error '50290' | Excel Discussion (Misc queries) | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Question for about using IF formula LEFT function at the same time | Excel Worksheet Functions | |||
formula that calc the diff in time, with a less than function? | Excel Worksheet Functions |