Thread: [Solved] MailMerge - Time showing 12:30 instead of 0:30
View Single Post
 
Old 11-11-2011, 06:02 AM
Chris424 Chris424 is offline Windows XP Office 2007
Novice
  
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, 11 views)
File Type: doc MailMerge.doc (36.0 KB, 9 views)
Reply With Quote