Hi,

you need to create a custom format.

In Excel 2003 select the cells you want to format and choose Format, Cells,
Number tab, Custom. On the Type line enter
hhmm

Cheers,
Shane Devenshire
Microsoft Excel MVP

"awais" wrote in message
...