ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Time Please ! (https://www.excelbanter.com/excel-discussion-misc-queries/49450-time-please.html)

Anthony

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

Anthony

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


Gord Dibben

=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