| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting seconds to show in cell
I would like to be able to record the current time in certain cells, by using
the ctrl+shift+; keys. I have went to "Format Cells" "Number" tab, Selected "Time" and then chose the 24-hour display which included the seconds. My problem is that when I hit ctrl+shift+; the seconds always show up "00," example: 14:25:00. Please let know if there is a way to get the current second to show up on the time also. Excel 2007. Thanks!!!!!!!!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show amount of time in minutes and seconds? | Excel Worksheet Functions | |||
| Converting Julian Seconds with a macro to replace old seconds data | Excel Discussion (Misc queries) | |||
| Code to show current hour minute and seconds in a cell | Excel Programming | |||
| Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
| Subtracting time in excel to show in minutes:seconds | Excel Programming | |||
Threaded Mode
