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.

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