View Single Post
 
Old 11-05-2025, 01:22 AM
MishkaGrizzly MishkaGrizzly is offline Windows 11 Office 2021
Novice
 
Join Date: Nov 2025
Posts: 4
MishkaGrizzly is on a distinguished road
Default Convert whole number to hours and minutes and remove 0 hours or minutes

I would appreciate any help.

I have a merged field as a whole number for example, 60, 90, 45, 30.

I would like to convert that to hours and minutes, so the output would look something like this.

1 hr
1 hr 30 min
45 min
30 min

Notice that if its 0 hours or 0 min then I don't need to output anything.

Many thanks in advance
Reply With Quote