Skip to content

Instantly share code, notes, and snippets.

@kelso

kelso/gist:5356418

Created April 10, 2013 16:54
Download ZIP

Revisions

  1. kelso created this gist Apr 10, 2013.
    14 changes: 14 additions & 0 deletions gistfile1.txt
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,14 @@
    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 | clock_type_id | job_id |
    +----------+---------------+--------+
    7am 1 1
    8am 2 1
    8am 3 2
    9am 1 2
    3pm 2 2