Hello,
I would like to edit a cell without prompting me seconds.
My time cell looks like 12:30 as I want but when I double click it I get seconds then when editing looks like 12:30:00… How to remove seconds from editing?
Thank You,
Ivan
The numeric value of the Time always contains seconds even if you format the time value az HH:MM. Therefore the 12:00:00 … 12:30:05 … 12:30:29 values will be appeared as 12:30. The formula edit box always will show you the precise value even if the seconds equals to zero.
1230.ods (8.4 KB)
2 Likes