Minutes to Hours:Minutes



Most of our tasks are factored by the minute, for manufacturing purposes. Let's say a task takes a minute to run, but I'm doing it 125 times. Simple math = 125 minutes. What I want to show is a cell is how many hours and minutes that is for easier human readability on the reports. So that I know that it'll take 2 hours and 6 minutes, or 2:06.

How would I accomplish this in Smartsheets?

I know how I'd do it on paper:

125/60 = 2.086333

Focus on the decimal:

.086333 * 60 = 5.17998

Round up to 6

Add the hour back on and format:


I could do this in java but for the life of me can't figure out how to do it on Smartsheets

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!