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 (09) do not have the leading zero. Hope this make sense. How can I get the leading zero to show up for 0109 minutes?
Best Answers

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!
Answers

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
Categories
Check out the Formula Handbook template!