Excel Help

[loosemarbles]

Hoping for some collective PH help ...

I have a list of dates & times (staff in & out) as follows:

25/08/2016 16:28 Out
25/08/2016 13:08 In
25/08/2016 12:06 Out
25/08/2016 08:16 In
24/08/2016 16:00 Out
24/08/2016 12:59 In
24/08/2016 11:56 Out
24/08/2016 08:06 In

Is there an easy Excel formula/work around to calculate the number of hours worked? Obviously we can pull out the time, but then we would have to manually work out the dates side of it.

Help appreciated!

[loosemarbles]

The date & time are in the same column, with the corresponding in/out in a separate column.

I've had a look at that formula - I wouldn't even know where to put that or use it!

[loosemarbles]

Thanks all.

Having gone through the data, it is dependent on people actually logging in and out correctly ... argh ... some days apparently they never left!

I think if the data is complete, then any of the above might work, but given I have to correct the lines etc (signing in back from lunch, but not out beforehand etc), it might be easier to do it manually!