![]() |
Time Please !
Hi,
Maybe a simple question but. is it possible to place a formula in a cell to gain the current time from the PC's clock?? Just like getting today's date, I type =TODAY() thanks |
answered my own question
=NOW() "Anthony" wrote: Hi, Maybe a simple question but. is it possible to place a formula in a cell to gain the current time from the PC's clock?? Just like getting today's date, I type =TODAY() thanks |
=NOW()
If you don't want that to update at every re-calc just hit SHIFT + CTRL + ; to enter a static time instead of using the NOW() Function. Gord Dibben Excel MVP On Sat, 8 Oct 2005 13:14:03 -0700, "Anthony" wrote: Hi, Maybe a simple question but. is it possible to place a formula in a cell to gain the current time from the PC's clock?? Just like getting today's date, I type =TODAY() thanks |
All times are GMT +1. The time now is 03:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com