#1
|
|||
|
|||
MailMerge - Time showing 12:30 instead of 0:30
Hello,
I have a mailmerge which pulls data from a spreadsheet. It shows the outages of services. So if a service is down from 14:00 to 14:30 the duration is 0:30. This displays fine in excel (format [h]:mm) but when I pull this into a mailmerge it shows 12:30 instead of 0:30. I have tried defining the format in the mailmerge itself but cannot get around this? Code:
MERGEFIELD Time_to_resolve_hhmm\@"[h]:mm" \*Mergeformat Can anyone help? |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
That worked perfectly! Thank you so much for your help
|
Thread Tools | |
Display Modes | |
|
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 |