Hello everyone!
I am using the following VBA macro, which inputs timestamps every time a key combination (alt+right arrow in this case) is pressed:
Sub AltRight_Sub()
On Error Resume Next
Cancel = True
Cells(Rows.Count, 2).End(xlUp).Offset(1) = Format(Now, "HH:MM:SS")
End Sub
I would like this to display decimal seconds as well. Is there a quick change I can make to the formatting of "HH:MM:SS" which will work?
So far I've tried "HH:MM:SS.0" and similar variations, which only appends to the seconds whatever follows the period; and "HH:MM:SS:MS" and similar variations, but that only redisplays the minute and second values.
I am using Excel 2011 on Mac OS 10.9.1
Thanks!
NeuroSpace
Nobody need give their time towards a solution for your problem if it's already been solved.
Please, if you're going to cross post, do it properly.
Numerous forums refer to this http://www.excelguru.ca/content.php?184 for an understanding of why.
http://www.mrexcel.com/forum/excel-q...ons-macro.html
http://www.excelforum.com/excel-prog...functions.html
http://www.excelguru.ca/forums/showt...-now-functions
Any others?
Bookmarks