Try:
{QUOTE{SET tval{MERGEFIELD Time_sampled}}{IF{=tval}={REF tval} "{SET ss{=tval*86400 \# 0}}{SET hr {=INT(ss/3600) \# 0}}{SET mn {=INT((ss-hr*3600)/60) \# 0}}{SET AMPM{IF{hr}< 12 "AM" "PM"}}{=MOD(hr+11,12)+1 \# 0}:{mn \# 00} {REF AMPM}" {tval \@ "hh:mm AM/PM"}}}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|