Closed Thread
Results 1 to 4 of 4

Splitting Multiple Days From a Data Set?

  1. #1
    Registered User
    Join Date
    06-09-2020
    Location
    Wisconsin
    MS-Off Ver
    Office 365
    Posts
    5

    Splitting Multiple Days From a Data Set?

    So here is my problem... I have a very large and very basic data set which includes 4 columns of data (production line #, order #, date started, date finished). I'm trying to manipulate the data to compare when certain pairs of production lines are running at the same time. A lot of the orders only run for a part of a day and for those I could just use the starting date for comparison. If I just use the starting date for the other orders though, I will miss the days when a line ran for more than one day on a particular order. Is there a way or formula that anyone knows to add lines of data for the other days of these multi-day orders so I can accurately compare the data by date? I basically just want to know whether a particular line ran during a particular day of the year, but how do I get that from the data set I have to work with? If anyone has any thoughts or guidance, I'd greatly appreciate it.

    Thanks

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,779

    Re: Splitting Multiple Days From a Data Set?

    Welcome to the forum.

    There are instructions at the top of the page explaining how to attach your sample workbook.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    06-09-2020
    Location
    Wisconsin
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Splitting Multiple Days From a Data Set?

    Here is a small sample

    In this instance Line 9 shows an order that was run from 3/31 until 4/2. By just using a start date, I lose the information that line L10 also ran on 4/1. How do I get this to count as a "run day".
    Attached Files Attached Files

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,779

    Re: Splitting Multiple Days From a Data Set?

    As you have chosen to post in the Commercial Services section, this thread is now closed.

    https://www.excelforum.com/commercia...-data-set.html

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cutting Data to the Latest 365 days for multiple sets of data
    By improvemyknowledge in forum Excel General
    Replies: 5
    Last Post: 09-12-2018, 10:00 PM
  2. [SOLVED] average time value between data in column for multiple days
    By bolo11 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-14-2017, 04:22 AM
  3. Spliiting 1 row of data into 2 lines based on next unique value
    By michelle 1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2016, 02:59 PM
  4. Replies: 15
    Last Post: 06-17-2016, 01:59 AM
  5. [SOLVED] Subtract dates to give a total amount of days - Multiple Data
    By t_man000 in forum Excel General
    Replies: 2
    Last Post: 07-23-2015, 11:14 PM
  6. Spliiting calls equally formula
    By skate1991 in forum Excel General
    Replies: 3
    Last Post: 03-09-2015, 07:50 AM
  7. Replies: 8
    Last Post: 07-02-2014, 01:39 PM

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