This is such an easy question, I'm almost embarrassed to be asking it...

I have a column that shows time. The cell shows the time the way I want it:
2:00 PM. The formula bar shows this: 2:00:00 PM. Im using the
spreadsheet as part of a Merge document, and its merging the time as 2:00:00
PM.

Ive set the column format to Time, and chose the format that reads 1:30 PM.
It doesnt change anything. I tried changing the column format to Text, but
it gives me the decimal equivalent of the time. Ive tried copying and
pasting using every single option under €œPaste Special€� but nothing is
working.

Please help me before I do violence to my monitor!