NeuroSpace
New member
- Joined
- Feb 1, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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!
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!