I have spreadsheet with a lot of observations, taken every 30th minutes (48 observations during a day).
However, the data comes in a quite annoying format. Instead of writing dd:mm:yyyy hh:mm: (e.g. 01.01.2012 10:00), the data comes as a date text stamp!
It looks like this where HH stands for every half hour (so HH=1=30min). Also, you can see how the timestamps are done simoultaniously for several types of units.
HOW do I convert this into something reasonable that Excel understands?
Thanks in advance