Converting number of seconds to Minutes and Seconds
I have a query from a user where he has a total number of seconds and a total number of calls. He wants to format the output so that instead of 100 seconds per call he would get 1 Minute 40 Seconds per Call.
When it comes to dates/times, and MOD I am clueless, so any help would be appreciated. I can see how it might work in my mind, but simply cannot translate it to SQL.