[LLChoi]

I'm trying to get a list of times for a music competition merged, and as
such, the fields I am merging are sometimes coming from a directly entered
time (like the first one in each group) or a calculated formula (based on the
start time and length of performance of the entrant before). I am getting
the results I want if the time is directly entered, but not if it is the
result of a formula. The codes I'm using a

{ MERGEFIELD "Competition" \@ "h:mm am/pm" \* MERGEFORMAT }

which returns : 1/1/1900 8:34:30 AM instead of just: 8:34 AM

The formula in the Excel spreadsheet is simply:

=R2+O2+TIME(0,2,0)

where R2 is the previous entrant's start time, O2 is the total time of the
previoius entrant's program, then 2 minutes are added for judges to write
comments.

I think I'm doing it correctly, it seemed to work last year, but the
formatting is not happening this year. I just don't want to go through all
the entries to edit out the date and seconds for each time I want to list on
each merge file, and I've got 6 different merge documents that I'm trying to
create.