topic Re: How to get the time diffrence in Alerting

How to get the time diffrence

9198459056 — Fri, 27 Aug 2021 09:47:45 GMT

I have 2 time A anb B is in HH:MM:SS format ..then how to get the difference of A and B in same format

Re: How to get the time diffrence

9198459056 — Fri, 27 Aug 2021 09:48:42 GMT

I used diff=(B-A) and then diff=A-B nothing worked

Re: How to get the time diffrence

9198459056 — Fri, 27 Aug 2021 09:49:48 GMT

i asked so many questions but till now did not the single answer of any of my question🙄

Re: How to get the time diffrence

scelikok — Fri, 27 Aug 2021 10:46:11 GMT

Hi @9198459056,

You need to convert time to epoch format for calculation. You can use the below options;

Difference is duration format; eval diff=tostring(round(strptime(A,"%H:%M:%S")-strptime(B,"%H:%M:%S")),"duration") Difference in seconds; eval diff=round(strptime(A,"%H:%M:%S")-strptime(B,"%H:%M:%S"))