MailMerge

macropod · #1 11-13-2011, 05:10 AM

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.

Chris424 · #2 11-17-2011, 05:51 AM

Quote:

Originally Posted by macropod

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hyperlink in MailMerge	samndi	Mail Merge	11	12-14-2011 01:59 PM
Mailmerge	dkub	Mail Merge	35	12-07-2011 11:35 PM
Meeting Appointment Not Showing Local Time	april	Outlook	2	06-23-2011 08:57 AM
Add a period of time to a referenced "Time" cell?	derelyth	Excel	4	03-27-2011 04:31 PM
Help with mailmerge???	foxtrot1981	Mail Merge	0	12-03-2010 08:21 AM