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-13-2011, 05:10 AM

macropod

Windows 7 64bit MailMerge - Time showing 12:30 instead of 0:30

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,514

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.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« 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:13 PM.