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.

C33ba229997f0aed4de672cee1efb2dd?s=128

Shanelle Recheta

April 13, 2021
Tweet

Transcript

  1. None
  2. None
  3. None
  4. None
  5. None
  6. None
  7. None
  8. None
  9. None
  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),"")|||
  11. None
  12. None
  13. None
  14. None