difference between two times

Hi Guys,

I'm really sorry to bother you but I'm trying to see if you can help me please.. I have attached the demo spreadsheet I'm trying to work with however what I'm trying to see is the difference from when the team member logs out and logs back in.

In the example posted I'm trying to get the difference from cell c1 to when they log back in b2.


I have been reading forums but still no luck I'm not sure if it's the AM and PM thing or what but I still can't seem to get it.. sorry to bother you.

Thanks in advance

Ads

Try this in D1:
=IF(A1<>A2,"",TIMEVALUE(LEFT(B2,LEN(B2)-2))-TIMEVALUE(LEFT(C1,LEN(C1)-2)))
Copy down

0.005555556 equals 8 minutes.

Change the cell format to "Time".

Sorry that there is something wrong with my previous formula, e.g. if logs out is 12:59PM and logs back in is 1:00PM.
This may correct:
=IF(A1<>A2,"",TIMEVALUE(LEFT(B2,LEN(B2)-2)&" "&RIGHT(B2,2))-TIMEVALUE(LEFT(C1,LEN(C1)-2)&" "&RIGHT(C1,2)))