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

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