I have data that was collected over 4 days, with the times being recorded hh:mm:ss. However, since it was over multiple days, the same time, for example 14:58:30 repeats 4 times. So when I try to graph it, the data points for my y-axis for the different days (i.e. Mon, Tues, Wed, Thurs) all graph together wherever 14:58:30 happens to be on the x-axis. How do I make sure the data (ex: 2) for a given timepoint (ex:14:58:30) on Monday does not graph at the same x-axis timepoint (i.e. 14:58:30) for the Tuesday data (ex:3).
The way I know the different days, is because I know what day my instrument started collecting data (i.e. Monday) and when it stopped (Thursday). So I visually marked Day 1 as the first 24 hour pass, the 2nd day as the next 24 hour pass etc.
Any input appreciated