Jul 26 2020 09:56 PM
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.)
Jul 26 2020 10:36 PM - edited Jul 26 2020 10:38 PM
@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.