Hi Jim,
The cell shows the time correctly but when you look at the formula bar, the
seconds & AM/PM still shows and this is how my data is coming over when I
merge into Word.



"J Sedoff" wrote:

In the cells (whole column or whole row will work the same way) of interest,
set the cell format to Custom "h:mm" (for 1:30) or to Custom "hh:mm" (for
01:30). (My understanding is that you do not want seconds NOR AM/PM,
correct? If not, just use the "1:30 PM" format under the Time category.)

To do this, right-click on the cell/row/column of interest and select
"Format Cells," go to the "Number" tab then choose the appropriate category
("Custom" for the first two, "Time" for the third), and then the "Type,"
click "OK" when you are finished.

Hope this helps, Jim