So it's all the output from this field that's showing as 12:00 PM? Even when not using the IF test? If so, that's most likely because the data contain something other than times alone in that field.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|