MailMerge - Time showing 12:30 instead of 0:30

		Microsoft Office Forums > Microsoft Word > Mail Merge
MailMerge - Time showing 12:30 instead of 0:30

FAQ

Thread Tools

Display Modes

11-17-2011, 05:51 AM

Chris424

Windows XP MailMerge - Time showing 12:30 instead of 0:30

Office 2007

Novice

Join Date: Nov 2011

Posts: 2

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:27 PM.