I'm using Tasker and am trying to set up a profile that would track how many hours I spend at work. I've managed to set up the tracking part, which inserts the data in a Google Spreadsheet like this:
Arrived 2017-03-11 10:15 Left 2017-03-11 12:40 Arrived 2017-03-11 13:00 Left 2017-03-11 15:50 Arrived 2017-03-11 17:30 Left 2017-03-11 21:20
What I'm wondering is: How can I add the final piece - counting the hours at my office, provided that I leave it several times per day. So for this example, the result is 9:05:00. I guess what I'm looking for is a loop, that would go trough each date, calculate differences, and add all of them into a cell.
How would I go about doing this?