$30 off During Our Annual Pro Sale. View Details »

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