Simply put subtract the two date columns, and display the positive time without the negative, i.e. 2nd row should display 00:00:12 instead of 23:59:48.
I like the readable format HH:MM:SS
, and would prefer to keep it that way.
(https://i.stack.imgur.com/m2dH4.png)
Tried DATEDIFF
but I don’t like the displayed format.
Cheers
New contributor
James is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2