Upgrade to Pro — share decks privately, control downloads, hide ads and more …

How to track your hours with IFTTT

How to track your hours with IFTTT

I made this step-by-step guide to track how you spend your time each day with a simple button press on IFTTT.

Shanelle Recheta

April 13, 2021
Tweet

More Decks by Shanelle Recheta

Other Decks in Technology

Transcript

  1. Copy-paste this code on “Formatted row” {{OccurredAt}} ||| =IF(ISODD(ROW()), "Started",

    "Stopped") |||=IF(ISEVEN(ROW()),ROUND(((DATEVALUE(REGEXEXTRACT(INDIRECT(AD DRESS(ROW(),COLUMN()-2,4)),"\w+ \d{2}, \d{4}")) + TIMEVALUE(REGEXEXTRACT(INDIRECT(ADDRESS(ROW(),COLUMN()-2,4)), "\d{2}:\d{2}[A|P]M$"))) - ( DATEVALUE(REGEXEXTRACT(INDIRECT(ADDRESS(ROW()-1,COLUMN()-2,4) ), "\w+ \d{2}, \d{4}")) + TIMEVALUE(REGEXEXTRACT(INDIRECT(ADDRESS(ROW()-1,COLUMN()-2,4)) , "\d{2}:\d{2}[A|P]M$")))) * 24, 2),"")|||