Hello folks
I want to write a script that will run periodically and change things when the delta between now and the time of the creation of a row.
Anyone know how to calculate this on the spreadsheet?
Thank’s in advanced
I have a calendar application, which compares the old date with now, if confirmed it brings the word delete to the column, and the agedendado script searches through it daily and if it finds that word it deletes the line, I don’t know if it will serve you.
this is the formula I use
= SEERRO (ARRAYFORMULA (SE (C2: C = “”; “”; SE (DATADIF (C2: C; NOW (); “D”)> 2; “DELETE”; “”))))
this is the script
2 Likes
Hi Sandro.
I believe you have an answer based on Roberto’s formula already, but just a warning if you want the difference to be in seconds/minutes/hours then do a further math inside that.
If you need more help feel free to comment here.