Thread: Mail Merge Field - Trying to divide time however receiving !Syntax, ;
View Single Post
 
Old 09-24-2014, 12:58 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,359
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
Are your field's internal braces (i.e. { }) created via Ctrl-F9? You can't just type them.

Furthermore, it looks like some of your data are times, expressed in HH:mm. Unless your 'Total Quantity' is always a whole number of hours, you will not get meaningful results with your current approach, as Word's formula fields cannot evaluate times this way. A moderately-complicated field code would be needed to convert the time into minutes, do the division then convert the results back to HH:mm -

{QUOTE{SET AvgTime {={={MERGEFIELD Total_Quantity \@ hh}*60}/{MERGEFIELD Total_People} \# 0}}{=INT(AvgTime/60)*100+MOD(AvgTime,60) \# "00:00"}}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practicable to add them via any of the standard Word dialogues.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote