Good morning all,
I am new here and pretty good with excel but having a roadblock on one of the Dashboards I am creating.
I have a list of people with multiple rows that have times in them. I need to be able to capture JUST the earliest time and the latest time for each person.
See below. Bill Smith has several rows for one day. He logged into the system at 9:00 (I need to capture that) And then logged out and back in a few times this day. His last log out was at 17:04. I need to capture that as well.
Capture.PNG
Bookmarks