View Single Post
 
Old 11-17-2011, 05:51 AM
Chris424 Chris424 is offline Windows XP Office 2007
Novice
 
Join Date: Nov 2011
Posts: 2
Chris424 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Hi Chris,

With your workbook, change the formula in H3 to:
=IF(G3="","Unknown",TEXT(G3-F3,"h:mm"))
With the mailmerge main document, delete the '\* Mergeformat' switches. You shouldn't need a switch for the Time_to_resolve_hhmm field.
That worked perfectly! Thank you so much for your help
Reply With Quote