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?
Help Article Resources
Check out the Formula Handbook template!