Thank you David. I changed to custom hh and getting 7:12 or 2:24 instead of
7:00 and 2:00. Is there any way around it?
--
RV


"David Biddulph" wrote:

Format Axis/ Number/ Custom:
hh
--
David Biddulph

"RV" wrote in message
...
I am trying to use the following hours to display on the X axis labels in a
chart. The chart is displaying hours and minutes. How can the hours only
be
displayed on (X) asix labels?

Date/Time 1:00 2:00 3:00 4:00 5:00 6:00 7:00 8:00 9:00 10:00 11:00 12:00
13:00 14:00 15:00 16:00 17:00 18:00 19:00 20:00 21:00 22:00 23:00 0:00

--
RV