Combine 2 numbers into minutes & seconds in sql view
I have two numbers in separate columns in my sql view. One is just the number of minutes and the other is the number of seconds. How can I combine these into one value that shows mm:ss? I tried just doing [Mins] + ':' + [Seconds] but if the seconds are 0 then it looks like this: 2:0. I need it to look like this: 2:00. How can I do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome.
ASKER