+ Reply to Thread
Results 1 to 2 of 2

Group Time

  1. 06-01-2021, 06:07 PM #1
    bmanager
    bmanager is offline
    Registered User
    Join Date
    07-09-2016
    Location
    Sydney, Australia
    MS-Off Ver
    2010
    Posts
    7

    Group Time

    I have a general log of all access times for contractors.
    I'm looking to get:
    - Start time (per day)
    - End time (per day)
    - Total time per day for contractors

    I've cleaned up the data but not knowing the terms I'm not sure on how to tackle this. Help would be appreciated.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-01-2021, 06:20 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,705

    Re: Group Time

    What does this data mean? For example, you have 24 times for the same person on March 2. It's just a list of times. How do you determine start time or end time for the day based on just a list of times?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Group by time period and by day
    By BRISBANEBOB in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-09-2020, 08:15 PM
  2. [SOLVED] Identify Time and Group it
    By Prashanth Gangala in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-15-2019, 03:55 AM
  3. How to group data with respect to time
    By abdul khader in forum Excel General
    Replies: 3
    Last Post: 10-03-2018, 08:44 AM
  4. [SOLVED] Date time Group
    By Tordah in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-10-2017, 03:44 PM
  5. [SOLVED] forming group and finding total for each group and select all group scoring above benchmar
    By raghusri in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-12-2017, 01:41 PM
  6. [SOLVED] Group values of each person - Time avaiable vs Time assigned the task
    By matinha052 in forum Excel General
    Replies: 8
    Last Post: 10-26-2016, 07:19 AM
  7. insert group header -- above a group of rows -- based on consistent value within the group
    By macrorookie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2014, 10:26 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1