|
|
#4
03-03-2020, 02:28 PM
|
||||
|
||||
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] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Mail Merge Repeat Record a certain number of times
|
stacey_e | Mail Merge | 7 | 07-07-2023 01:27 AM |
| Rounding to split up times. | GregM | Excel | 1 | 03-27-2019 11:58 PM |
|
Rounding a merge calculation to whole number
|
finners01 | Mail Merge | 1 | 12-03-2018 04:55 AM |
| Using 3 different fields, several times in same document but not en mass - should I use mail merge? | shoughton | Mail Merge | 1 | 06-24-2015 02:46 PM |
| Mail merge error? | SRE | Outlook | 0 | 01-11-2010 05:54 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode