display no seconds in time format [h]

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

Regards

Roger Govier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MROUND time 2
Displaying Degrees Minutes Seconds 1
Adding hours and minutes 1
Format for elapsed time 2
stopwatch times 7
I need to find the yy/mm/dd AND hh:mm:ss between 2 time stamps 5
limit on [h]:mm time format? 14
Subtracting 37 hours from a cell containing format [h]:mm 2

Back
Top