| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel: How to insert current time (static) to the nearest second?
When inserting the current time you press CTRL + SHIFT + ; and it displays it
in hours and minutes only. By formatting the cell to display seconds, it will give 00 seconds rather than more specific time to the nearest second. Can this function be adjusted to be more precise and display time to the nearest second rather than just the nearest minute? Note: The "=NOW()" function does display time to the nearest second, but I cannot use it in this case because it is not static (i.e. updates). |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert static time | Excel Worksheet Functions | |||
| how do I insert the current time (static) and date in a cell? | Excel Discussion (Misc queries) | |||
| How to enter current static time in Excel in 00:00:00.0 format? | Excel Worksheet Functions | |||
| Excel static current date/time problem | Excel Worksheet Functions | |||
| how do i insert the current time into a cell, and show different . | Excel Discussion (Misc queries) | |||
Threaded Mode
