I am trying to get total hours and mints of each emp from sql database date wise from date time column below snap for your refrence please need your support how to do.

there is type column as well where with entry 0 and 1 its mean 0 IN and 1 Out.

Below Picture for your refrence how i have data in sql and how i need report.

Please your support will be highly appreciated.