Tried this method years ago - it's not very accurate. Here's an alternative:

Speaking of hiking, I'm doing two charity walks over the next few weeks.
The first is this sunday, in aid of neuroendocrine tumour therapy in Oxford. I have a...

Ok, next step is to join your data table to this hourly breakdown table. Try first with a full outer join as shown, this helps pinpoint any issues with aligning...

Dedupe the table.