| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date and time updated automatically
Is there a way to have the date and time in cell g2 to constantly show the
currect time and date every second. Like a watch with a second hand. or undated every 15 minutes |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
date and time updated automatically
Hi Richard,
You can use ONTIME and using Excel as a Clock is a very bad choice, though updating every 15 minutes would not kill your usage. http://www.mvps.org/dmcritchie/excel/datetime.htm#clock and look for use of and links involving ONTIME- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Richard" wrote in message ... Is there a way to have the date and time in cell g2 to constantly show the currect time and date every second. Like a watch with a second hand. or undated every 15 minutes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Current date and time updated automatically | Excel Discussion (Misc queries) | |||
| How to automatically update the date any time the Excel is openned | Excel Worksheet Functions | |||
| automatically insert date and time into excel] | Excel Discussion (Misc queries) | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
Linear Mode
