+ Reply to Thread
Results 1 to 4 of 4

Login/logout hrs - is there a quicker way?

  1. #1
    Registered User
    Join Date
    05-10-2016
    Location
    Perth, WA
    MS-Off Ver
    2016
    Posts
    2

    Login/logout hrs - is there a quicker way?

    Good evening all, firstly let me say thank you to all the helpers on here, reading some of this stuff has made me realise there are still WONDERFUL human beings out there.

    I have a report (attached).. Our app logs driver logon/logoff times. This can occur multiple times during the day as you'll see in the data. The issue I have is a can't seem to easy report on the TOTAL number of hours logged on with each driver.
    It's had me scratching my brain for 2 weeks knowing full well there must be a rather simple way, but I'm just missing something?
    Column C is the driver which is the main logon/logoff hours I'm looking for.


    I'll take any help I can get. Thanks in advance. (very will to learn too!).

    -Jeff
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Login/logout hrs - is there a quicker way?

    Hi jeffao:

    Reviewing your data a question pops out...

    Is a driver allowed to login more than once before he/she has logout?

  3. #3
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Login/logout hrs - is there a quicker way?

    Data Range
    C
    D
    E
    F
    1
    driver
    action
    human_date
    Time
    2
    1-Driver
    login
    5/2/2016
    18:01:34
    3
    1-Driver
    login
    5/2/2016
    18:05:12
    4
    1-Driver
    login
    5/2/2016
    19:48:26
    5
    1-Driver
    logout
    5/2/2016
    19:48:48
    6
    1-Driver
    logout
    5/2/2016
    20:04:05
    7
    1-Driver
    login
    5/2/2016
    20:39:18
    8
    1-Driver
    logout
    5/2/2016
    20:41:40
    9
    1-Driver
    login
    5/3/2016
    5:39:21


    That driver has 3 consecutive logins.

    How do you know which logout corresponds to which login?

    Also, will the time worked span past midnight?

    This looks like a nightmare!
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  4. #4
    Registered User
    Join Date
    05-10-2016
    Location
    Perth, WA
    MS-Off Ver
    2016
    Posts
    2

    Re: Login/logout hrs - is there a quicker way?

    Right? it is a nightmere!.

    Yes - the app pickups when they bring the screen forward on their phone as a login, so it'll have multiple login times but only a couple of logout times.

    This is my disaster at the moment and I have to do this EVERY week, and at the moment is killing me, wasting time

+ 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. Login and Logout Template
    By carlzilla in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2020, 10:55 AM
  2. Need a login and logout tracker
    By Shakil777 in forum Excel General
    Replies: 10
    Last Post: 01-27-2016, 06:52 AM
  3. Replies: 0
    Last Post: 02-17-2014, 07:44 AM
  4. 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
  5. Login Logout Report
    By excelnightmare in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2011, 01:45 PM
  6. Login Logout userform
    By poitachi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-19-2010, 03:01 PM
  7. First login & last Logout
    By Vikky in forum Excel General
    Replies: 2
    Last Post: 08-19-2006, 01:20 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