Thread: [Solved] Convert whole number to hours and minutes and remove 0 hours or minutes
View Single Post
 
Old 11-05-2025, 04:01 AM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,501
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
You could use a field construction like:
{=INT({MERGEFIELD Minutes}/60) \# "0' hr '"}{=MOD({MERGEFIELD Minutes},60) \# "0' min'"}
or
{=INT(«Minutes»/60) \# "0' hr '"}{=MOD(«Minutes»,60) \# "0' min'"}
where 'Minutes' is your datafield name.

NOTE: The field brace pairs (i.e. '{ }') for the above field code examples are created in the mailmerge main document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from here. Nor is it practicable (for the most part) to add them via the standard Word dialogues. Likewise, the chevrons (i.e. '« »') - are part of the actual mergefields, inserted via the 'Insert Merge Field' dropdown (i.e. you can't type them or copy & paste them from here). The spaces shown in the field constructions are all required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote