cell format in Open Office

[#1]

Using open office, spreadsheet... I want to display time in a column of cells... as  14:00   but the default is showing 14:00:00

I have tried to change it,....but cannot get it to work using the toolbar or the "format" .. please can someone point me to the right thing to click on !

cheers

[#2 · Accepted solution]

@shutter just tried with LibreOffice, select the cell range,select Format cells,Time and top of list is the HH:MM format

[#3]

@MisterW   Ah. Yes !.... thanks for that.... what a pity it is a "hidden" thing.... whereas, most others are "drop down" menu`s...

Much apprreciated.

Thanks again.