Plotting magswitch states on a timeline in a Google spreadsheet?
Following a thread regarding combining Twine and IFTTT, I've created an autoupdating spreadsheet, which saves all the magswitch state changes like this:
January 11, 2013 at 07:41PM Closed
January 11, 2013 at 07:41PM Open
January 11, 2013 at 07:52PM Closed
Now, is there a way to plot a timeline based on this data, that would graphically show for how long each state lasted? I imagine this would require reformatting the time and finding a proper visualisation type, but really no idea how to do this. Anyone tried anything similar? Thanks!