Microsoft Office Forums - View Single Post - [Solved] Convert whole number to hours and minutes and remove 0 hours or minutes

Thread: [Solved] Convert whole number to hours and minutes and remove 0 hours or minutes

View Single Post

Old

11-05-2025, 07:36 AM

MishkaGrizzly MishkaGrizzly is offline

MishkaGrizzly is offline

MishkaGrizzly uses Windows 11

Windows 11 MishkaGrizzly uses Office 2021

MishkaGrizzly uses Office 2021

Office 2021

Novice

The original poster

Join Date: Nov 2025

Posts: 4

MishkaGrizzly is on a distinguished road

Default

I believe I solved my own question!

{IF {=INT(«Minutes»/60)} > 0 {=INT(«Minutes»/60) \# "0' hr '"}}
{IF {=MOD(«Minutes»,60)} > 0 {=MOD(«Minutes»,60) \# "0' min'"}}

Might not be best way, but it seems to work

Reply With Quote