总计登录时间

Question

I am using MySQL 5.6 and want to calculate sum (in-mins) against below data through SQL statement:

third column for just information and means i am expecting 15 value

 
Status   Date_Time            Total_hours

LogIn    2016-01-14 00:00:00

LogOut   2016-01-14 09:00:00    9
LogIn    2016-01-14 10:00:00

LogOut   2016-01-14 14:00:00    4
LogIn    2016-01-14 16:00:00

LogOut   2016-01-14 18:00:00    2

              hours Total ==>>  15

Answer 1

Updated to include your table and field names.

SELECT
loggedin.InOutStatus,
MAX(loggedin.Date_Time) AS start_time,
loggedout.Date_TimeAS end_time,
TIMEDIFF(MAX(loggedin.Date_Time), loggedout.Date_Time)
FROM empstatuslog AS loggedin
INNER JOIN empstatuslog AS loggedout ON (loggedin.InOutStatus = loggedout.InOutStatus
                                     AND loggedout.Date_Time > loggedin.Date_Time)
WHERE loggedin.InOutStatus= 'LogIn'
AND loggedout.InOutStatus= 'LogOut'
GROUP BY loggedin.InOutStatus