Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Time.
Is it possible in Excel to put "Live Time" in particular cell. ie cell should change its value every second. Thanks Harshawardhan Shastri India |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dynamic Time.
hi
you can use the formula =now() to put "real" time in a cell but it will only change when the sheet calculates. there are a number of events that cause this but it can be eratic. if you want a ticking clock that ticks non-stop, see this site. http://www.mvps.org/dmcritchie/excel/datetime.htm it's all about time and dates. very usefull site. explains a lot. it's a large site and the timers are down towards the bottom. it does require that you run code to make the clock tick non'stop and runing other code will interfer with the clock. Regards FSt1 "HARSHAWARDHAN. S .SHASTRI" wrote: Is it possible in Excel to put "Live Time" in particular cell. ie cell should change its value every second. Thanks Harshawardhan Shastri India |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Place a Dynamic Date + a Certain Time in a Cell | Excel Worksheet Functions | |||
Dynamic chart generation: Run time Error '1004: Method 'Cells' of object'_Global' fai | Charts and Charting in Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Dynamic Time Display | Excel Worksheet Functions |