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

Mark Forums Read

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,467

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 06:44 AM.