display no seconds in time format [h]

F

Finolac

Have used the [h] mm ss formatting to add up times over 24 hours but only
want to display the hh mm and not the seconds (ss) the format option does not
seem available, any ideas gratefully received.
 
R

Roger Govier

Hi

Format>Cells>Number>Custom and in the white pane just type [h]:mm

Regards

Roger Govier
 
Top