How to calculate totalActivity and lastActivity?

Question

Hi Team

 

I need some help, i have these two fields and want to filter their data types, but need some help as to how to work this out in sql server. Meaning TotalActivity must this format as output and LastActivity.

Oct 13 at 3:41am
21:02:04 // Must always counts when a user logs in and out