Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-11-2011, 06:02 AM
Chris424 Chris424 is offline MailMerge - Time showing 12:30 instead of 0:30 Windows XP MailMerge - Time showing 12:30 instead of 0:30 Office 2007
Novice
MailMerge - Time showing 12:30 instead of 0:30
 
Join Date: Nov 2011
Posts: 2
Chris424 is on a distinguished road
Default 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
I have attached the spreadsheet and mailmerge




Can anyone help?
Attached Files
File Type: xls Dailylog.xls (159.0 KB, 9 views)
File Type: doc MailMerge.doc (36.0 KB, 7 views)
Reply With Quote
  #2  
Old 11-13-2011, 05:10 AM
macropod's Avatar
macropod macropod is offline MailMerge - Time showing 12:30 instead of 0:30 Windows 7 64bit MailMerge - Time showing 12:30 instead of 0:30 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 11-17-2011, 05:51 AM
Chris424 Chris424 is offline MailMerge - Time showing 12:30 instead of 0:30 Windows XP MailMerge - Time showing 12:30 instead of 0:30 Office 2007
Novice
MailMerge - Time showing 12:30 instead of 0:30
 
Join Date: Nov 2011
Posts: 2
Chris424 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
MailMerge - Time showing 12:30 instead of 0:30 Hyperlink in MailMerge samndi Mail Merge 11 12-14-2011 01:59 PM
MailMerge - Time showing 12:30 instead of 0:30 Mailmerge dkub Mail Merge 35 12-07-2011 11:35 PM
MailMerge - Time showing 12:30 instead of 0:30 Meeting Appointment Not Showing Local Time april Outlook 2 06-23-2011 08:57 AM
MailMerge - Time showing 12:30 instead of 0:30 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 01:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft