Need help regarding working hours calculation

[Sampat]

I have excel containing door access of some people as 7C_ODCU_DR02_IN_RDR for a time indicating moving in of the person & 7C_ODCU_DR01_OUT_RDR for a time indicating moving out.

Now I need to calculate the total time every person spent inside the office. (that means, time between 1st in & 1st out + time between 2nd time in & 2nd time out and so on)

I tried to make html with the supplied add in, but with my Excel 2007, I'm unable to do so. So, uploading a screenshot. Apologies for the inconvenience.

 

[barry houdini]

Assuming there is always an OUT time for each IN time then you can get your total time with a formula like this

=SUMIF(A:A,B:B,"7C_ODCU_DR0?_OUT_RDR",D:D,"Sengupta, Sampat")-SUMIF(A:A,B:B,"7C_ODCU_DR0?_IN_RDR",D:D,"Sengupta, Sampat")

format result cell as [h]:mm