gistfile1.txt

Starts working at 7am at Job A
Starts travelling at 8am from Job A
Starts working at 9am at Job B
Finished for the day at 3pm



| datetime | activity | job_id | duration | adjusted_dateimte | adjusted_duration
+----------+---------------+--------+
  7am        work           1       1              9am              0 (9am - 8am)
  8am        break          1       
  8:15am     travel         1
  9am        work           2
  3pm        finish         2

job 1 starts at 9pm and finished at 5pm

First Clock duration should probably be 0