Thread: [Solved] Mail merge rounding error for times?
View Single Post
 
Old 03-03-2020, 02:28 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
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]
Reply With Quote