Alerting

How to get the time diffrence

9198459056
Loves-to-Learn Everything

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

Labels (1)
0 Karma

scelikok
SplunkTrust
SplunkTrust

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"))

 

If this reply helps you an upvote and "Accept as Solution" is appreciated.
0 Karma

9198459056
Loves-to-Learn Everything

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

0 Karma

9198459056
Loves-to-Learn Everything

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

 

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

This is the third post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...