Best formula to count login - logout time

[Akbarov]

Hey Dear community,

i have big list of users login and logout time, i need to count users work time, i use minifs and maxifs to find login and logout time minifs-maxifs=result , is there any other ( easy ) way to do this?

Names are in D:D and times are in J:J

 

[mikerickson]

Can you give us a small sample of some data, including lay-out, and the desired results?

 

[Akbarov]

here is link to download excel file http://alqoritm.com/table.xlsx

 

[pjmorris]

Not sure you ever got a solution, so perhaps this will help.

Firstly, I converted the data to a table.
Then in next free column add: =[@Tarix]+[@Saat] the formula will be copied down automatically if the table was formed correctly.
In the next free copy add: =IF(MOD(ROW(),2)=1,[@Column1]-L1,"") this too will be copied down and will provided the duration between alternate rows.

This solution should take account of finish times that go overnight. It assumes that every individual will enter and then leave so that their first entry is a start time and the next a finish time. If for some reason this is incorrect you will need to add a dummy entry or delete the incorrect values.

Hope this helps.