Time format
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" wrote:
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
a
*13:30
13:30:55
13:30:55
01:30:55PM
01:30:55PM
I have changed the settings in control panel
|