| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date and time in cell
Hi there,
I need a way of getting the latest date and time in a cell without having to manually update it every minute! I can't see to figure out how to do this. I need something like currenttime. Can anyone guide me. Any help greatly appreciated. Suzanne |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date and time in cell
=NOW()
-- Regards, Peo Sjoblom "Grd" wrote in message ... Hi there, I need a way of getting the latest date and time in a cell without having to manually update it every minute! I can't see to figure out how to do this. I need something like currenttime. Can anyone guide me. Any help greatly appreciated. Suzanne |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date and time in cell
Perfect
Thanks "Peo Sjoblom" wrote: =NOW() -- Regards, Peo Sjoblom "Grd" wrote in message ... Hi there, I need a way of getting the latest date and time in a cell without having to manually update it every minute! I can't see to figure out how to do this. I need something like currenttime. Can anyone guide me. Any help greatly appreciated. Suzanne |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date and time in cell
Does =Now() do what you want?
-- -John Please rate when your question is answered to help us and others know what is helpful. "Grd" wrote: Hi there, I need a way of getting the latest date and time in a cell without having to manually update it every minute! I can't see to figure out how to do this. I need something like currenttime. Can anyone guide me. Any help greatly appreciated. Suzanne |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date and time in cell
=NOW()
"Grd" wrote: Hi there, I need a way of getting the latest date and time in a cell without having to manually update it every minute! I can't see to figure out how to do this. I need something like currenttime. Can anyone guide me. Any help greatly appreciated. Suzanne |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date and time in cell
you need something like clocks on the internet? real time clock?! If so,
you'll need some VBA, if not =now() should do the job (as already mentioned). "Grd" wrote in message ... Hi there, I need a way of getting the latest date and time in a cell without having to manually update it every minute! I can't see to figure out how to do this. I need something like currenttime. Can anyone guide me. Any help greatly appreciated. Suzanne |
| 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 | |||
Hybrid Mode
