I have some cells that are formatted as hours and minutes i.e. [h]:mm
.
If no value exists in a cell I want the cell to show 0:00 without having to manually type.
It needs to be user friendly, so if I copy cells from another spreadsheet and there are no values the 0:00 should not become blank.
0
. But I think you cannot do it for cells which are blank, i.e. no value at all.