Good Day Experts!
I am using the DATEDIFF in a qry to get the seconds between a Start and End time. I would like to have the seconds in minutes and seconds if applicable.
For example, I am getting 81 seconds on a record. How do I get it to return 1:21?
Here is the line in my qry:
SUM(DATEDIFF(ss, [KEY START TIME], [KEY END TIME])) AS 'Key Time'