V Vilius Sep 16, 2003 #2 I try to enter current time (Ctrl+Shift+, but there are no seconds. After i change cell to custom (hh:mm:ss), seconds are always equal to 00. How can i fix this problem? I need just insert auto time WITH SECONDS. Thanx in advance.
I try to enter current time (Ctrl+Shift+, but there are no seconds. After i change cell to custom (hh:mm:ss), seconds are always equal to 00. How can i fix this problem? I need just insert auto time WITH SECONDS. Thanx in advance.
D Dave Smith Sep 16, 2003 #3 It is kind of strange isn't it? Try this macro: Sub InsertTimeWithSeconds() ActiveCell.Value = Time End Sub -Dave
It is kind of strange isn't it? Try this macro: Sub InsertTimeWithSeconds() ActiveCell.Value = Time End Sub -Dave
D Dave Smith Sep 16, 2003 #4 Using Activecell instead of Selection will more closely match the behavior of Ctrl+Shift+; . -Dave
