+ Reply to Thread
Results 1 to 12 of 12

login id change during the day?

Hybrid View

  1. #1
    Registered User
    Join Date
    08-16-2016
    Location
    Hungary
    MS-Off Ver
    2015
    Posts
    4

    Re: login id change during the day?

    This is an example (sorry I dont know how to attach excel file):
    Where the Expected result is 2 it means that there were two different logins on that day, where the result is 1, there was no change during the day.

    Date transaction time Login id Expected result
    2016.06.01 7:27 604 2
    2016.06.01 8:24 604 2
    2016.06.01 9:44 604 2
    2016.06.01 11:28 604 2
    2016.06.01 12:36 604 2
    2016.06.01 14:12 602 2
    2016.06.01 14:57 602 2
    2016.06.01 15:08 602 2
    2016.06.01 15:16 602 2
    2016.06.01 15:58 602 2
    2016.06.01 16:02 602 2
    2016.06.01 16:16 602 2
    2016.06.01 17:17 602 2
    2016.06.01 17:55 602 2
    2016.06.01 20:21 602 2
    2016.06.01 20:25 602 2
    2016.06.02 7:21 604 2
    2016.06.02 7:50 604 2
    2016.06.02 7:59 604 2
    2016.06.02 8:53 604 2
    2016.06.02 9:57 604 2
    2016.06.02 10:34 604 2
    2016.06.02 10:42 604 2
    2016.06.02 11:10 604 2
    2016.06.02 11:19 604 2
    2016.06.02 11:35 604 2
    2016.06.02 13:22 604 2
    2016.06.02 13:53 606 2
    2016.06.02 13:54 606 2
    2016.06.02 14:24 606 2
    2016.06.02 15:14 606 2
    2016.06.02 15:33 606 2
    2016.06.02 16:04 606 2
    2016.06.02 16:14 606 2
    2016.06.02 17:08 606 2
    2016.06.02 18:55 606 2
    2016.06.02 19:20 606 2
    2016.06.02 19:47 606 2
    2016.06.02 21:11 606 2
    2016.06.02 21:28 606 2
    2016.06.03 6:19 602 1
    2016.06.03 7:30 602 1
    2016.06.03 8:22 602 1
    2016.06.03 8:27 602 1
    2016.06.03 8:28 602 1
    2016.06.03 8:53 602 1
    2016.06.03 8:58 602 1
    2016.06.03 9:08 602 1
    2016.06.03 11:13 602 1
    2016.06.03 11:17 602 1
    2016.06.03 12:12 602 1
    2016.06.03 12:25 602 1
    2016.06.03 12:29 602 1
    2016.06.03 13:11 602 1
    2016.06.03 13:15 602 1
    2016.06.03 13:48 602 1
    2016.06.03 14:02 602 1
    2016.06.03 14:14 602 1
    2016.06.03 14:49 602 1
    2016.06.03 16:06 602 1
    2016.06.03 16:51 602 1
    2016.06.03 16:53 602 1
    2016.06.03 17:05 602 1
    2016.06.03 17:31 602 1
    2016.06.03 17:44 602 1
    2016.06.03 17:47 602 1
    2016.06.03 18:21 602 1
    2016.06.03 18:31 602 1
    2016.06.03 18:49 602 1
    2016.06.03 18:52 602 1
    2016.06.03 18:55 602 1
    2016.06.03 19:01 602 1
    2016.06.03 19:32 602 1
    2016.06.03 20:05 602 1
    2016.06.03 20:05 602 1
    2016.06.03 20:21 602 1
    2016.06.03 20:47 602 1
    Last edited by ze4lot; 08-17-2016 at 02:15 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. formula for Early login Time & Late Login Time
    By Rushendra in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-03-2016, 10:22 AM
  2. Any excel formula to get first login and last login data
    By sandesh joshi in forum Excel General
    Replies: 5
    Last Post: 07-11-2014, 11:18 AM
  3. Re-Login after Login attempt failed
    By raw_geek in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-09-2014, 05:24 AM
  4. Replies: 0
    Last Post: 02-17-2014, 07:44 AM
  5. [SOLVED] Login sheet rather than login form?
    By mdovey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2013, 05:17 PM
  6. login and logout time , with total login time ,break> 1 hours
    By shrinivasmj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2013, 05:37 AM
  7. find the login user and saving /login the name
    By belkin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2008, 08:24 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1