Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-29-2013, 07:07 PM
macropod's Avatar
macropod macropod is offline How to transform hours into minutes in mail merge Windows 7 32bit How to transform hours into minutes in mail merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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 ppochelon,

You'd need to use a formula field:
{={MERGEFIELD time \@ hh}*60+{MERGEFIELD time \@ mm}\# 0}

Note: The field brace pairs (ie '{ }') for the above example are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Tags
mailmerge field, time format



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Duplication of address on merge RICKY Mail Merge 1 09-26-2012 03:14 PM
How to transform hours into minutes in mail merge Conditional merge fields in mail merge Aude Mail Merge 1 01-06-2012 07:38 PM
How to transform hours into minutes in mail merge From a beginner: Mail Merge using Windows Mail mhalpern705 Mail Merge 3 12-16-2011 04:58 AM
How to transform hours into minutes in mail merge Saving INDV mail merges During the mail merge sedain121 Mail Merge 2 10-04-2011 07:52 PM
How to transform hours into minutes in mail merge Documents Take 5 Minutes To Open Farrar Word 1 07-23-2007 02:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:46 AM.


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