+ Reply to Thread
Results 1 to 2 of 2

Identifying Text Variations and Counting

  1. #1
    Registered User
    Join Date
    06-10-2016
    Location
    London, England
    MS-Off Ver
    Mac 2011 14.6.0
    Posts
    1

    Identifying Text Variations and Counting

    I have an excel file which lists all employees at my office in a column. Running across the top are times of the day (every 30 minutes e.g. 13:00, 13:30, 14:00 etc.) and I have a separate sheet for each day. Within this table I fill out the project name that each employee is working on for all the hours (or half an hours) of the day that they work. Some work on multiple projects each day and some work just one, everyone works slightly different hours. I need to find a way to summarise each day so that for each employee I can clearly see the project names of what they have worked on and how many hours they have done this for.

    I could use count if, but they could be working on any one of 100 projects so cannot create a separate function for each of these. Does anyone know how I can summarise the data I have?? I don't mind whether this is in another column to the side or a separate worksheet.

    Help would be greatly appreciated, thank you!!!

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Identifying Text Variations and Counting

    Hi,

    Unless you capture a time start and time end for each record you won't be able to summarise the hours.

    But personally I'd capture the data in a regular database so that you can analyse any statistics with a Pivot Table. Certainly avoid putting each day's data in a separate sheet. That's just inefficient.

    See attached for one example.
    Attached Files Attached Files
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. [SOLVED] finding address of nth occurrence of text within sheet including selected variations.
    By Kramxel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-24-2015, 05:00 AM
  2. [SOLVED] Counting Unique Values - Slight variations do not seem to work properly
    By Karroog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-29-2014, 01:07 PM
  3. How to rearrange/create variations of text?
    By excelrookie123 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-04-2014, 10:32 PM
  4. [SOLVED] validate 1 item has 5 variations; if not add missing variations
    By ccampbell14 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-25-2013, 03:03 PM
  5. conditional formula for identifying criteria and not counting
    By tanglin10 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-16-2013, 10:58 PM
  6. counting format variations
    By tonyfrier in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-28-2012, 04:47 AM
  7. [SOLVED] Identifying and counting duplicates
    By ngarutoa in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-21-2005, 08:45 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1