Splitting row in function of time
Hello all, I have a data frame that looks like this: http://r.789695.n4.nabble.com/file/n4077622/Capture.png I would like to know if it's possible to split a single row into two rows when the time frame between "beg" and "end" overlaps midnight. I want to compare the frequency of each activity for each day so a row for a phase that overlaps on two dates unbalances the graphs I create with this data. Ex:
From the original row:
http://r.789695.n4.nabble.com/file/n4077622/Capture2.png Note: "phasetime" is only a difftime between "end" and "beg". "phaseno" and "activity" should stay the same for the two new lines. Here is a sample of my data that covers a few days: http://r.789695.n4.nabble.com/file/n4077622/example.txt example.txt Thank you to anyone who takes the time to read this and any idea will be welcome PEL -- View this message in context: http://r.789695.n4.nabble.com/Splitting-row-in-function-of-time-tp4077622p4077622.html Sent from the R help mailing list archive at Nabble.com.