laravel The difference between more than one time with removed with the departure time

I have table contains

#   car_id   time   car_status  date
1   5       08:00   start       14-10-2019
2   5       09:30   leave       14-10-2019   
3   5       10:00   back        14-10-2019  
4   5       15:00   leave       14-10-2019 
5   5       16:00   back        15-10-2019 
6   5       15:00   leave       15-10-2019 

laravel i want calculate the times cars works and remove time car_status is leave

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2MeOaBl
via IFTTT