I am bringing data with appointment Times over from another program. I am
using a TIME formula to subtract 15 minutes off to let person know when to
show for appointment.

Problem that is occurring is how the time shows. The time in the cell
itself shows as 1:30 but when you click on the cell & view it in the formula
bar, it shows as 1:30:00 AM. I'm Mail Merging (WORD) this data for letters
and do NOT want the full time with seconds and AM/PM to show on the letter.
How do I format this in EXCEL so only the 1:30 shows?

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

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