Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add Date And Time in a cell.
I want to add the time and date for a cell, but I want these date and time
to be automatically updated itself with each passing day, and second. So when I log on this excel sheet later, the cell will show a different date and time in which I am currently in. How do I accomplish this? Is this possible at all? |
#2
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add Date And Time in a cell.
use the Now() function - this is volatile and will be updated after each
sheet calculation takes place. put the following in the cell required - it formats to date and time (which you can change using cell format) =NOW() Cheers Nigel "Raymond" wrote in message ... I want to add the time and date for a cell, but I want these date and time to be automatically updated itself with each passing day, and second. So when I log on this excel sheet later, the cell will show a different date and time in which I am currently in. How do I accomplish this? Is this possible at all? |
#3
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add Date And Time in a cell.
Be aware that this will update if the sheet recalculates some time after you
login to the sheet. This may be what you want, but it will not be showing your start time for that day. -- HTH RP "Nigel" wrote in message ... use the Now() function - this is volatile and will be updated after each sheet calculation takes place. put the following in the cell required - it formats to date and time (which you can change using cell format) =NOW() Cheers Nigel "Raymond" wrote in message ... I want to add the time and date for a cell, but I want these date and time to be automatically updated itself with each passing day, and second. So when I log on this excel sheet later, the cell will show a different date and time in which I am currently in. How do I accomplish this? Is this possible at all? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding time to date-time formatted cell | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |