Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

"Insert current time" overrides column format


In Calc, I have a column of time formatted as HH:MM. I use the (ctrl+shift+;) "insert current time" shortcut frequently. Unfortunately, every time I do this, it overrides the column format and inserts it as HH:MM:SS AM in the cell which is quite annoying. I can reset the whole column format, but I don't want to do this every single time I input a time.

Is there a way to change the default format of "insert current time"? Or make it such that the column format always overrides the format "insert current time" wants to use?