This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have some data describing the length of production runs on a production line. So one column specifies the line, the second column specifies the completion date of the production run, and the third column specifies the length in days of the production run.
I need to convert this into a by-day schedule of when the line was run. So one column would specify the line just like before, but the second column would specify a single day, and the third column would specify the proportion of the day that the line was run (i.e., maximum = 1).
I've attached an xls illustrating the data I have to start with and what I'd like to end with. I feel like the Generate Rows tool should work but I can't get it to work quite right.
Thank you for reading and for any help you can provide.
I have a similar requirement with the difference that I want to convert not only into days but also into hours (clock 0 to 23), because my production duration is in hours. In attachmtnt are my raw data.
Duration 1/04:10:00 means 1 day, 4 housr and 10 min.