Time format

[Ron Barker]

Hi I would be grateful for help with time format in excel 2003. I want to
show the time without seconds showing. At the moment the only choices I have
are:

*13:30
13:30:55
13:30:55
01:30:55PM
01:30:55PM

I have changed the settings in control panel

 

[Mike H]

Ron,

Assuming these are properly formatted times simply apply a Custom format of
hh:mm

to the cell(s)

Note that formats only change what you see on the sheet, the underlying
value remains the same.

To apply the format, select the cell(s) and right click and select 'format
cells' select 'custom' and rnter the format on the right.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Ron Barker]

Mike

Thanks for the timely response. There is no 'customs' to chose from!

 

[Mike H]

Hi,

You have to follow this precisely.

Select the cell(s)
Right click in the selected area
Left click 'Format cells'
In the popup select 'Custom' on the left side.
On the right you will see a box with 'Type' above it and the box may contain
another format.
Click in the box and delete what's in there
enter hh:mm in the box
Click OK

Your done
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Ron Barker]

Mike

Got it: Thank you very much.

Kind regards

Ron Barker