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