Home |
Search |
Today's Posts |
#1
|
|||
|
|||
@ NOW time command
I cannot get the SECONDS to show when I use the time stamp [ CNTRL+ SHFT+ ;
]. I want to use excel as a time study tool--so I need to have the seconds to register when I log the time stamp. Does anyone know how to configure this in excel? |
#2
|
|||
|
|||
Hi Time study Guy
You can add a macro if you want in your personal xls See below a example from J.E CTRL-Shift-: will only insert minutes. If you want it to insert seconds, the way I do it is to put these in a workbook in your XLStart folder (e.g., Personal.xls),: in the ThisWorkbook module: Private Sub Workbook_Open() Application.OnKey "+^:", "CtrlShiftColon" End Sub and in a regular code module: Public Sub CtrlShiftColon() With Selection .NumberFormat = "hh:mm:ss" .Value = Time End With End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Time study Guy" <Time study wrote in message ... I cannot get the SECONDS to show when I use the time stamp [ CNTRL+ SHFT+ ; ]. I want to use excel as a time study tool--so I need to have the seconds to register when I log the time stamp. Does anyone know how to configure this in excel? |
#3
|
|||
|
|||
I think you will have to use a macro to get the format desired.
-- Don Guillett SalesAid Software "Time study Guy" <Time study wrote in message ... I cannot get the SECONDS to show when I use the time stamp [ CNTRL+ SHFT+ ; ]. I want to use excel as a time study tool--so I need to have the seconds to register when I log the time stamp. Does anyone know how to configure this in excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering numbers to display a time format | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions |