I have a time table that looks as follows: (1x135 timetable)
Each column represents an hour and minute timestamp, see below for example:
05:42:00 AM 11:02:00 AM 03:28:00 PM 08:53:00 PM 12:44:00 AM 02:07:00 AM 06:43:00 AM ...
and this goes on for 135 columns, the times represent a recording of a variable on particular dates which I have in a seperate timetable. What I would like to do is seperate the hours into days, and attach the date.
So I would hopefully end up with something like this:
The first day would include the first four values, that is time_table(1,1:4) because they occurred between the first 24 hour interval. The second day would include the next seven values after that, that is time_table(1,5:11), because they occurred in the second 24 hour interval and so on.
Is there any way to attach a date to the values between the first 24 hour interval, for example the first four values would have the date 11/1,2021, the second 24 hours worth of values would have 12/1/2021, and so fourth.
Any help much appreciated, thank you