+ Reply to Thread
Results 1 to 4 of 4

Formula or VBA to group Time Values

  1. 07-14-2016, 08:38 PM #1
    zaska
    zaska is offline
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    359

    Formula or VBA to group Time Values

    Hello I have time values in the below format in
    Start Time End Time
    01:27 03:58
    01:30 03:56
    01:33 04:15
    01:35 03:41
    01:39 04:20
    01:45 04:21
    01:59 04:38
    02:02 04:37

    I would like to Group Them based on the following table

    06:00 To 14:00 - Schedule-I
    14:00 To 22:00 - Schedule-II
    22:00 To 06:00 - Schedule-III

    Thank you
    Reply With QuoteRegister To Reply
  2. 07-14-2016, 08:41 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,940

    Re: Formula or VBA to group Time Values

    Will you be grouping on the start times or the end times?
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 07-14-2016, 08:45 PM #3
    zaska
    zaska is offline
    Forum Contributor
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    359

    Re: Formula or VBA to group Time Values

    Start Times
    Reply With QuoteRegister To Reply
  4. 07-14-2016, 09:26 PM #4
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,940

    Re: Formula or VBA to group Time Values

    Maybe this:

    Please Login or Register  to view this content.
    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] Help! Need formula to group similar text & numeric values onto seperate graph
    By TylerLuk1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-30-2015, 01:26 PM
  2. How to group time values into ranges?
    By chiccaboom in forum Excel General
    Replies: 1
    Last Post: 02-23-2015, 07:08 PM
  3. Sort and group names, then sum associated numerical values for each group, sort total
    By Joe Dren in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2014, 05:54 PM
  4. 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
  5. Formula to find records based on other values in group
    By hk106 in forum Excel General
    Replies: 5
    Last Post: 01-09-2012, 04:50 PM
  6. Using values from one group of cells to format a separate group of cells
    By cyne in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-17-2011, 04:05 AM
  7. macro that puts a formula in a group of cells then goes and values those cells
    By caliskier in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2007, 02:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1