Thanks Don,

That works; but adds a 0 padding on the left.

"Don Guillett" wrote:

hH:mm

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
custom format as he:mm

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"WJason" wrote in message
...
I have a table of times in the format "Time, 13:30" using Arial font. For
asthetics, I decided to center the time in the cells. This results in
the
colons being out of line. Is there a way to center the cell on the
colon?
Similar to the "decimal tab stop" in Word that aligns columns to the
decimal
point.

Jason