Nested IF Statement - I think

[FanofExcel18]

Trying to put together a formula to tell me the number of hours based on the following parameters:
1. Time between Online/Offline
2. Online always is first
3. How much time between Online and Offline for the day
4. Some times multiple entries for a person within a day
5. Sometimes Online will come up twice back to back. Formula would need to ignore that

Date	Time	Full Name	Online/Offline
05/29/2019	8:06 AM	John Smith	Online
05/29/2019	8:06 AM	John Smith	Offline
05/29/2019	10:30 AM	John Smith	Online
05/29/2019	12:47 PM	John Smith	Offline
05/29/2019	2:11 PM	John Smith	Online
05/29/2019	4:19 PM	John Smith	Offline
05/29/2019	7:45 AM	Jane Doe	Online
05/29/2019	7:45 AM	Jane Doe	Offline
05/29/2019	8:37 AM	Jane Doe	Online
05/29/2019	8:37 AM	Jane Doe	Offline
05/29/2019	1:03 PM	Jane Doe	Online
05/29/2019	1:03 PM	Jane Doe	Offline
05/29/2019	7:57 AM	Jim Smith	Online
05/29/2019	10:29 AM	Jim Smith	Online
05/29/2019	12:09 PM	Jim Smith	Offline

<tbody>
</tbody>

 

[Joe4]

Assuming that your data is in Columns A-D, your title row is on row 1, and your first row of data in on row 2, place the following formula in E2 and copy down for all rows:

=IF(AND(C2=C1,D2="Offline",D1="Online"),ROUND(A2+B2-A1-B1,8),"")

This will show you the duration as each one is closed ("Offline").

 

[FanofExcel18]

Assuming that your data is in Columns A-D, your title row is on row 1, and your first row of data in on row 2, place the following formula in E2 and copy down for all rows:

=IF(AND(C2=C1,D2="Offline",D1="Online"),ROUND(A2+B2-A1-B1,8),"")

This will show you the duration as each one is closed ("Offline").

This was great! I'm still struggling with:
Sometimes Online will come up twice back to back. Formula would need to ignore that

 

[Joe4]

Sometimes Online will come up twice back to back. Formula would need to ignore that

It already does. Did you try that situation?

Maybe in that situation the data doesn't look like I think it does. Can you post an example where it is not working correctly?