How to subsctract Time

[Mathkar_kunal]

Hello,

I need to check time difference.
my flow is like automation will trigger after each 15 mins and connect to Jira Api.
if open ticket is there then it will work on it and if some condition not satisfied then ticket will move to pending and it will write ticket key with time in excel.
when after 15 mins it will again check excel and here condition is like diff between time and current time in excel > 30 mins.

and if >30 then i need to take same tikcet and work on it .

how can i achieve this?

for ex,
after moving to pending auto will write in excel -
ticket key time
EJCS-123 1:45

at 2 o clock it will check → 45 - 00 = 45 which is wrong it is actually 15 mins
at 2:15 it will check - > 45 - 15 = 30 which is right
at 2:30 it will check → 45-30 = 15 which is wrong as it actually 45 mins and i need to get pending ticket here as it is >30 mins.

how i can achieve this?
help me on same which approach should i take

[yedukondaluaregala]

@Mathkar_kunal

In excel try to enter along with the date. like 18-02-2026 13:45:00

now when you read the excel and store the value in assing activity,
exceltime = Datetime.parse(row(“Time”).tostring)
After that now take assign activity and get the current time, like take an assign activity, in To Section create a variable called currentDatetime = Now

Now take one more assign activity, create a variable in To section called diffTime

diffMinutes = (currentDatetime - excelTime).TotalMinutes

Now use your condition in if activity diffMinutes >30 like this

Happy Automation!!

[Mathkar_kunal]

Thank you worked this solution

[Mathkar_kunal]

previously i was writing 18-02-2026 20:24:44 this value using write line and manually coping in excel from output, that time worked.
but now when i am entering using automation in excel using write cell and with below expression

and reading then i am getting below error

help me on same

[yedukondaluaregala]

Change the variable that your giving output for read cell.
Change it as string after that you can convert to datetime.