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
|