David Noël
David Noël ✭✭✭✭
edited 07/28/23 in Formulas and Functions

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?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!