cancel
Showing results for 
Search instead for 
Did you mean: 

cell format in Open Office

FIXED
shutter
Community Veteran
Posts: 21,835
Thanks: 3,620
Fixes: 60
Registered: ‎06-11-2007

cell format in Open Office

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 REPLIES 2
MisterW
Superuser
Superuser
Posts: 11,151
Thanks: 3,423
Fixes: 260
Registered: ‎30-07-2007

Re: cell format in Open Office

Fix

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

Superusers are not staff, but they do have a direct line of communication into the business in order to raise issues, concerns and feedback from the community.

shutter
Community Veteran
Posts: 21,835
Thanks: 3,620
Fixes: 60
Registered: ‎06-11-2007

Re: cell format in Open Office

@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. Wink