Thread: [Solved] Convert whole number to hours and minutes and remove 0 hours or minutes
View Single Post
 
Old 11-05-2025, 12:43 PM
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
Change the:
{=INT({MERGEFIELD Minutes}/60) \# "0' hr '"}
or
{=INT(«Minutes»/60) \# "0' hr '"}
to:
{=INT({MERGEFIELD Minutes}/60) \# "0' hr ';;"}
or
{=INT(«Minutes»/60) \# "0' hr ';;"}

Likewise, change the:
{=MOD({MERGEFIELD Minutes},60) \# "0' min'"}
or
{=MOD(«Minutes»,60) \# "0' min'"}
to:
{=MOD({MERGEFIELD Minutes},60) \# "0' min';;"}
or
{=MOD(«Minutes»,60) \# "0' min';;"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote