I made this step-by-step guide to track how you spend your time each day with a simple button press on IFTTT.
View Slide
Copy-paste this code on “Formatted row”{{OccurredAt}} ||| =IF(ISODD(ROW()), "Started", "Stopped")|||=IF(ISEVEN(ROW()),ROUND(((DATEVALUE(REGEXEXTRACT(INDIRECT(ADDRESS(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),"")|||