Calculate total employee attendance

Hello,

I would like to calculate the total attendance of employees and the daily punch in and out time as well. I am encountering two issues: the first is when an employee punches in i.e. today and punches out a few hours after midnight the following day. I tried formatting the result in various ways but can't get the correct result. Also would it be possible to automate the process somehow? You can see the exact format in the attachment below.

Thank you for looking