ROUNDDOWN

Question

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?

Carson Penticuff · Accepted Answer

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))

David Noël · Accepted Answer

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

Carson Penticuff · Accepted Answer

Happy to help!