Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Seconds when inserting time in cells
Hello
I'm using the CTRL+SHIFT+; to insert time into a cell. I have formatted the cell to display HH:mm:ss, but seconds are only displayed as Zeroes and never update. Can you please tell me how to stamp time including seconds? Thanks -- regards, jane93 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Seconds when inserting time in cells
Use =NOW(), then paste special/ values to keep the data without further
recalculation. -- David Biddulph "jane93" wrote in message ... Hello I'm using the CTRL+SHIFT+; to insert time into a cell. I have formatted the cell to display HH:mm:ss, but seconds are only displayed as Zeroes and never update. Can you please tell me how to stamp time including seconds? Thanks -- regards, jane93 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Seconds when inserting time in cells
You could use a macro that "steals" the ctrl-shift-colon keystroke.
If you want to try, create a workbook that includes this code and store it in your XLStart folder. Lots of people use a workbook named Personal.xls for this kind of thing. Option Explicit Sub Auto_Open() Application.OnKey "+^:", "'" & ThisWorkbook.Name & "'!Nowtime" End Sub Sub Auto_Close() Application.OnKey "+^:" End Sub Sub NOWTIME() On Error Resume Next With Selection .Value = Now .NumberFormat = "hh:mm:ss" End With If Err.Number < 0 Then Beep End If End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm jane93 wrote: Hello I'm using the CTRL+SHIFT+; to insert time into a cell. I have formatted the cell to display HH:mm:ss, but seconds are only displayed as Zeroes and never update. Can you please tell me how to stamp time including seconds? Thanks -- regards, jane93 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Seconds when inserting time in cells
Thanks for the macro -- it works great, and the web page stepped me through
how to load it. I am totally new to Excel macros, and am interested how you knew which functions to use? I am trying to use "help" in Excel, but I kind of have to know what I'm looking for! -- regards, jane "Dave Peterson" wrote: You could use a macro that "steals" the ctrl-shift-colon keystroke. If you want to try, create a workbook that includes this code and store it in your XLStart folder. Lots of people use a workbook named Personal.xls for this kind of thing. Option Explicit Sub Auto_Open() Application.OnKey "+^:", "'" & ThisWorkbook.Name & "'!Nowtime" End Sub Sub Auto_Close() Application.OnKey "+^:" End Sub Sub NOWTIME() On Error Resume Next With Selection .Value = Now .NumberFormat = "hh:mm:ss" End With If Err.Number < 0 Then Beep End If End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm jane93 wrote: Hello I'm using the CTRL+SHIFT+; to insert time into a cell. I have formatted the cell to display HH:mm:ss, but seconds are only displayed as Zeroes and never update. Can you please tell me how to stamp time including seconds? Thanks -- regards, jane93 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Seconds when inserting time in cells
It may be time to get a reference book.
I don't think you can go wrong by starting with John Walkenbach's books. Debra Dalgleish has a list of books at her site: http://www.contextures.com/xlbooks.html See if you can find them in your local bookstore/internet site and you can choose what one you like best. jane93 wrote: Thanks for the macro -- it works great, and the web page stepped me through how to load it. I am totally new to Excel macros, and am interested how you knew which functions to use? I am trying to use "help" in Excel, but I kind of have to know what I'm looking for! -- regards, jane "Dave Peterson" wrote: You could use a macro that "steals" the ctrl-shift-colon keystroke. If you want to try, create a workbook that includes this code and store it in your XLStart folder. Lots of people use a workbook named Personal.xls for this kind of thing. Option Explicit Sub Auto_Open() Application.OnKey "+^:", "'" & ThisWorkbook.Name & "'!Nowtime" End Sub Sub Auto_Close() Application.OnKey "+^:" End Sub Sub NOWTIME() On Error Resume Next With Selection .Value = Now .NumberFormat = "hh:mm:ss" End With If Err.Number < 0 Then Beep End If End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm jane93 wrote: Hello I'm using the CTRL+SHIFT+; to insert time into a cell. I have formatted the cell to display HH:mm:ss, but seconds are only displayed as Zeroes and never update. Can you please tell me how to stamp time including seconds? Thanks -- regards, jane93 -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to display seconds on time stamp? | Excel Worksheet Functions | |||
display no seconds in time format [h] | Excel Discussion (Misc queries) | |||
display minutes and seconds in excel | Excel Worksheet Functions | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
How do I get a cell to display degrees, minutes, seconds? | Excel Worksheet Functions |