How to calculate time difference from a single column

Hello All,

I have a report where I am having data like below.

Here I haveSwipe Date, swipt time for employee in to office and also another column time in or time out.

So I need to calculate how much time that an employee stayed inside office by using for each day.

Could any one please help how to do this.

Below is my sample data:

Empid           Name         Swipe Date              Swipe Time         Entry/Exit

Expected Out Put :

EMPID           Name            Swipe Date                    Total Time Inside Office