# ROUNDDOWN

Question. I have a column that is calculating time. So in that column I get total minutes comparing a few other columns. I then want the total minutes to convert to hours and minutes.

I am using this formula: =ROUNDDOWN([Total Down in Minutes]@row / 60, 0) + ":" + MOD([Total Down in Minutes]@row, 60)

The value it is returning is 2:3 since the total minutes are 123. I want this to read though, 2:03. Any minutes less than 10 (0-9) do not have the leading zero. Hope this make sense. How can I get the leading zero to show up for 01-09 minutes?

• See if this works for you:

=ROUNDDOWN([Total Down in Minutes]@row / 60, 0) + ":" + IF(MOD([Total Down in Minutes]@row, 60) < 10, "0" + MOD([Total Down in Minutes]@row, 60), MOD([Total Down in Minutes]@row, 60))

• Carson, thank you. This makes complete sense and hate I didn't think of the last part of that formula. Thank you again!

• Happy to help!

• See if this works for you:

=ROUNDDOWN([Total Down in Minutes]@row / 60, 0) + ":" + IF(MOD([Total Down in Minutes]@row, 60) < 10, "0" + MOD([Total Down in Minutes]@row, 60), MOD([Total Down in Minutes]@row, 60))

• Carson, thank you. This makes complete sense and hate I didn't think of the last part of that formula. Thank you again!

• Happy to help!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!