Hi IFTTT users, “Date and Time formulas”

Now that I have IFTTT and WFArchive both working I wanted to check for missing or extra records compared to my WFArchive database and the weatherflow history. Particularly when I turn off WiFi and also when I unplug my internet connection with WiFi still on, or crash everything with a power outage etc. (Those results are another story after some more experimenting).

Anyway I had to add some formulas to the Google sheets to make the date and time easier to use. And I figure those who are using the latest IFTTT Applet might find my formulas helpful.

I Inserted 2 columns to the left and pasted this formula into A1:

=DATEVALUE(MID(C1,FIND(",",C1)-2,2)&"-"&LEFT(C1,(FIND(" “,C1)-1))&”-"&MID(C1,FIND(",",C1)+2,4))

And I inserted this formula into B1:

=TIMEVALUE(MID(C1,FIND(":",C1)-2,5)&" "&RIGHT(C1,2))

Perhaps some new excel formulas may do it easier but my software was unable to use Datevalue() or Timevalue() with the format currently used in the IFTTT google sheets.

And if anyone wants to use the units from the other columns to use as numbers to graph or calculate you could use something like this to get the number from cell D1:

=LEFT(D1,(FIND(" ",D1)-1))

Question for @WFstaff

If you update the IFTTT Applet again is it possible to create a new one and leave the old one? Otherwise I am very hesitant to create any smartness to my google spreadsheets if it will keep changing.

cheers Ian