View Single Post
 
Old 04-28-2013, 05:05 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

In that case, you can skip all the start & end time calculations and reduce their fields in the body of the document to:
{SET ss {MERGEFIELD start}}
{SET ss {MERGEFIELD end}}
However, it's risky using the same bookmark names this way, so I'd suggest:
{SET ts {MERGEFIELD start}}
{SET te {MERGEFIELD end}}
and updating the REF fields accordingly.

Similarly, the ASStart & ASEnd and fields become:
{Set ASStart {IF{MERGEFIELD ALtStaffStart}= "X" "2" {MERGEFIELD ALtStaffStart}}
{Set ASEnd {IF{MERGEFIELD ALtStaffEnd}= "X" "2" {MERGEFIELD ALtStaffEnd}}
The only complication might be that the 'X' will now evaluate to '12:00AM'. In that case, replace "X" with "12:00AM".
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote