Minutes to Hours Conversion

[sathsaj]

Hi

Could you please help me how can I convert from 224,064 minutes to hours ? so the easy rule is 224,064/60= 3,7344 hours.
But I would like to read this as 3:44 mins, I tried searching , but no success

[sathsaj]

I think I found out myself =3,7344/1440*60=3:44

[josephteh]

224,064/60/24 then format the cell as h:mm

[tanasedn]

Please Login or Register  to view this content.

[tanasedn]

224,064/60/24 then format the cell as h:mm

LOL! What I am thinking about?

[sathsaj]

224,064/60/24 then format the cell as h:mm

thanks for the check

[sathsaj]

thanks tanasedn