Tasker Date/Time Calculations against 72h mark (from time-stamp)

21 views
Skip to first unread message

Razvan Baban

unread,
Nov 19, 2022, 2:58:48 PM11/19/22
to Tasker
I have this:

Task: Task Demo

A1: AutoSheets Get Cell [
Configuration: Spreadsheet ID: Sheet ID
Sheet Name: Demo Sheet Name
Cell Reference: F1
Output Name: timestamp
Timeout (Seconds): 60
Structure Output (JSON, etc): On ]

A2: If [ %timestamp ~ *AB* ]

A3: Flash [
Text: Huurayyy
Continue Task Immediately: On
Dismiss On Click: On ]

A4: Else
If [ %timestamp !~ *AB* ]

A5: Flash [
Text: Try again
Continue Task Immediately: On
Dismiss On Click: On ]


A6: End If
I've used some placeholders for A3 and A5.


Let me explain what I need. In the F1 cell I will have either empty or something like this: "AB - 12:35 / 19 Nov / 2022" (without the quotes obv) whereas  12:35 / 19 Nov / 2022 represents a time stamp generated by another task which works very well.

What I want to do and I got stuck:

In A3 I want a calculation based on the time stamp: Calculate if the difference from F1 cell is > or < than 72 hours. If it is greater then do "X" if is less than 72h do "X"

Any solution guys how to go about the calculation?
Reply all
Reply to author
Forward
0 new messages