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.

Hi

FormatCellsNumberCustom and in the white pane just type [h]:mm

Regards

Roger Govier



Finolac wrote:

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.