Calculate total time in office from checkin timestamp and checkout timestamp

[hubertdenie]

I have an excel list with name of employee, check-in timestamp (yyyy-mm-dd hh-mm-ss AM) and check-out time (yyyy-mm-dd hh-mm-ss AM). The timestamps are not marked as checkin or checkout unfortunately. I would like to calculate the time difference between the lowest time of date X and the latest time of date x per person. Furthermore, its important to note that sometimes employees forget to checkout.

Any suggestions?

[TABLE="width: 453"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Date[/TD]
[TD]Time[/TD]
[TD]Device#[/TD]
[TD]Operating Time[/TD]
[/TR]
[TR]
[TD]金峻[/TD]
[TD]2017/12/1[/TD]
[TD="align: right"]9:24:00 AM[/TD]
[TD]001[/TD]
[TD]2017/12/1 9:23:48[/TD]
[/TR]
[TR]
[TD]金峻[/TD]
[TD]2017/12/1[/TD]
[TD="align: right"]6:09:00 PM[/TD]
[TD]001[/TD]
[TD]2017/12/1 18:09:27[/TD]
[/TR]
[TR]
[TD]金峻[/TD]
[TD]2017/12/4[/TD]
[TD="align: right"]6:09:00 PM[/TD]
[TD]001[/TD]
[TD]2017/12/4 18:12:54[/TD]
[/TR]
[TR]
[TD]金峻[/TD]
[TD]2017/12/5[/TD]
[TD="align: right"]8:21:00 AM[/TD]
[TD]001[/TD]
[TD]2017/12/5 8:24:23[/TD]
[/TR]
[TR]
[TD]金峻[/TD]
[TD]2017/12/6[/TD]
[TD="align: right"]6:03:00 PM[/TD]
[TD]001[/TD]
[TD]2017/12/6 18:06:36[/TD]
[/TR]
[TR]
[TD]金峻[/TD]
[TD]2017/12/7[/TD]
[TD="align: right"]9:05:00 AM[/TD]
[TD]001[/TD]
[TD]2017/12/7 9:08:11[/TD]
[/TR]
[TR]
[TD]金峻[/TD]
[TD]2017/12/7[/TD]
[TD="align: right"]6:06:00 PM[/TD]
[TD]001[/TD]
[TD]2017/12/7 18:09:03[/TD]
[/TR]
</tbody>[/TABLE]