Extract first and last login time for each day only
On Friday, October 12, 2012 9:16:54 AM UTC-5, (unknown) wrote:
Help I export this from a diffrent source. Its a login logout report. Sometimes agents login and out many times during the day. I would like help with a formula that would give just the first login and last loging let's say this is for John, Doe Doe, John Sep 4, 2012 7:07:03 AM Sep 4, 2012 4:18:39 PM Doe, John Sep 4, 2012 4:19:26 PM Sep 4, 2012 4:19:35 PM Doe, John Sep 5, 2012 7:19:34 AM Sep 5, 2012 9:43:37 AM Doe, John Sep 5, 2012 9:43:45 AM Sep 5, 2012 3:19:37 PM Doe, John Sep 5, 2012 3:19:47 PM Sep 5, 2012 3:19:53 PM Doe, John Sep 5, 2012 3:20:20 PM Sep 5, 2012 3:20:28 PM So for Sep 4 I just want to see 9/4/2012 7:07 AM - 4:19 PM For Sep 5 I just want to see 9/5/2012 7:19 AM - 3:20 PM Thank you
Yes Isabelle, the data is in three columns name all the login times during the day and all the logout times durning the day.
|