ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Dynamic Time. (https://www.excelbanter.com/excel-worksheet-functions/203345-dynamic-time.html)

HARSHAWARDHAN. S .SHASTRI[_2_]

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

FSt1

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