I have 2 columns of dates and time (created date, created time, and Resolved date, and resolved time). Occassionally, a ticket will not be resolved until the next calendar day.
Created date Time: 28/03/2018 12:22PM
Resolved date Time: 29/03/2018 08:31AM
How do I calculate the total time the ticket took to resolved in hours and in minutes?
I need to calculate the average resolution time for each ticket.