Time Code

%3CLINGO-SUB%20id%3D%22lingo-sub-1547058%22%20slang%3D%22en-US%22%3ETime%20Code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547058%22%20slang%3D%22en-US%22%3E%3CP%3EI'd%20love%20to%20be%20able%20to%20generate%20time%20code%20into%20my%20Excel%20spreadsheet%2C%20but%2C%20barring%20that%2C%20I'm%20trying%20to%20enter%20a%20time%20of%20day%20time%20stamp%20into%20a%20column%20of%20cells%20that%20is%20formatted%20h%3Amm%3Ass.%20When%20I%20click%20SHIFT%2BCONTROL%2B%3A%20(shift%2Bcontrol%2Bcolon)%20I%20only%20get%20hour%20and%20minutes%2C%20with%20no%20seconds.%20I%20need%20the%20seconds%20too.%20I%20have%20set%20my%20computer%20clock%20to%20show%20running%20seconds%20but%20I%20can't%20get%20them%20into%20my%20spreadsheet.%20Any%20ideas%3F%20Thanks.%20(I'm%20using%20a%202017%26nbsp%3BMacBook%20Pro%2C%20running%20High%20Sierra%20and%20a%202015%20MacBook%20Pro%2C%20running%20Catalina.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1547058%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1547100%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20Code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547100%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740594%22%20target%3D%22_blank%22%3E%40StellaVindaloo%3C%2FA%3E%26nbsp%3BDon't%20really%20use%20this%20shortcut%20myself%2C%20but%20some%20some%20research%20on-line%20tells%20me%20that%20it%20indeed%20only%20picks-up%20the%20hour%20and%20minutes%20portion%20of%20the%20current%20time.%20To%20get%20the%20full%20time%20value%20in%20the%20active%20cell%2C%20you%20could%20assign%20your%20own%20keyboard%20short%20cut%20to%20the%20following%20macro.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-visual%22%3E%3CCODE%3ESub%20TS()%0A%20%20%20%20ActiveCell.Value%20%3D%20Time%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20format%20the%20%26nbsp%3Boutcome%20to%20your%20liking.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1548468%22%20slang%3D%22en-US%22%3ERe%3A%20Time%20Code%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548468%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThank%20you.%20I'll%20try%20that!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'd love to be able to generate time code into my Excel spreadsheet, but, barring that, I'm trying to enter a time of day time stamp into a column of cells that is formatted h:mm:ss. When I click SHIFT+CONTROL+: (shift+control+colon) I only get hour and minutes, with no seconds. I need the seconds too. I have set my computer clock to show running seconds but I can't get them into my spreadsheet. Any ideas? Thanks. (I'm using a 2017 MacBook Pro, running High Sierra and a 2015 MacBook Pro, running Catalina.)

 

2 Replies

@StellaVindaloo Don't really use this shortcut myself, but some some research on-line tells me that it indeed only picks-up the hour and minutes portion of the current time. To get the full time value in the active cell, you could assign your own keyboard short cut to the following macro.

 

Sub TS()
    ActiveCell.Value = Time
End Sub

 

and format the  outcome to your liking.

@Riny_van_Eekelen Thank you. I'll try that!