Is is possible to show only hours and minutes when editing a time cell?
Something which has bothered me for a long time: I have a sheet to hold my working times.
Everytime I want to change a time shown as 10:25
to lets say 10:27
and I go into edit mode (F2 or doubleclick) it gets shown as 10:25:00
.
It would be much more comfortable if it would be also 10:25
in edit mode (without seconds), because I only need to delete the minutes with backspace. Util now I have to use the arrow keys or have to delete the seconds also.
May sound like a tiny or irrelevant problem, but if you do it everyday, it's annoying and time consuming.
F2+del+del+new value+new value
, and no messy going to mouse or double-clicking or function keys to worry about.F2 + del + del + del (:ss) + del (m) + del(m) + new value + new value + enter
;-)F2 + del (m) [+ del(m)] + new value [+ new value] + enter