| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time and motion chart | Charts and Charting in Excel | |||
| Excel Time Manipulation | Excel Discussion (Misc queries) | |||
| conditional formatting with time values | Excel Discussion (Misc queries) | |||
| Time Sheets | New Users to Excel | |||
| unmet challenge | Excel Worksheet Functions | |||
Linear Mode
