I have a table which contains time management data. We have:
R = Registration
A = Arrival
D = Departure
Time information for A and D can be in the table multiple times for one of our employees. What I would like to do is show the amount of time between the R and the last D of the day.
So R = 08:00 and the last D = 18:30 so the time amount would be 10 hours and 30 minutes.
Is there any way to do this in MySQL?