If Statement (I think) - Need Help!

[FanofExcel18]

ssue: Need to calculate the times per person, per day using minimum/maximum (or that's how i figured it out). Each day, there could be multiple timestamps. Need to figure out the oldest and newest, then calculate the time in between that based on person and day.

Appreciate any help

Example data:

Date	Full Name	Online/Offline	Day
11/17/2019 1:03	John Smith	Online	Sun
11/17/2019 5:31	John Smith	Offline	Sun
11/17/2019 5:31	John Smith	Online	Sun
11/17/2019 5:31	John Smith	Offline	Sun
11/17/2019 7:50	Jane Doe	Online	Sun
11/17/2019 12:31	Jane Doe	Offline	Sun
11/17/2019 13:30	Jane Doe	Online	Sun
11/17/2019 1:03	John Smith	Online	Mon
11/17/2019 5:31	John Smith	Offline	Tue
11/17/2019 5:31	John Smith	Online	Wed
11/17/2019 5:31	John Smith	Offline	Thu
11/17/2019 7:50	Jane Doe	Online	Fri
11/17/2019 12:31	Jane Doe	Offline	Sat
11/17/2019 13:30	Jane Doe	Online	Sun

Formula that I came up with: =TEXT((MAX(A2:A5)-MIN(A2:A5)),"h"" hrs ""m"" mins """) ..This comes out to be 4 hr 28 mins... But I need to get it to the point where results will fill in this way:

	Sun	Mon	Tue	Wed	Thu	Fri	Sat
John Smith	4 hour 28 mins
Jane Doe

 

[Fluff]

Duplicate If Statement (maybe) that takes into consideration several factors

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.