The Twine forums are now archived. If you need help, please visit http://help.supermechanical.com

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!

Best Answer

Sign In or Register to comment.