![]() |
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 |
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 |
All times are GMT +1. The time now is 10:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com