I have pinned the “insert Current Time” tool to my main toolbar and whenever I use it either on a default number cell or a specifically formatted time cell I see what looks like the correct time but when I click on the cell, the representation in the value field indicates that a full stop and an extra 3 digit value have been appended viz: 21:00:45.539. Interestingly, the extra “parameter?” microsecond? doesn’t copy & paste into this text - just the anticipated HH:MM:SS.
Is it a bug?
F2, Ctrl+A, Ctrl+C, Esc, 17:56:23.314.
Ctrl+C without editing, only copy what do the cell show, not the internal value.
If do you change the format code of the cell to HH:MM:SS.000, then you can copy and paste with millisecond value.
Thanks @LeroyG. I wasn’t really concerned with copying it - more surprised that it included a microsecond value in the cell contents and then even more surprised that it didn’t copy it in full into this thread.
It doesn’t look like a parameter. As the stored value is a float you can have fractions of a second - wich are usually not shown because of the formatting.
21:00:45.539
I think those are milliseconds but not microseconds.
21:00:45.539000 You were saying 