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. View Slide

  2. View Slide

  3. View Slide

  4. View Slide

  5. View Slide

  6. View Slide

  7. View Slide

  8. View Slide

  9. View Slide

  10. 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),"")|||

    View Slide

  11. View Slide

  12. View Slide

  13. View Slide

  14. View Slide