Unable to find the difference in time between two events. What am I doing wrong?

[_dave_b]

Hello, I am trying to report on the differences in time between two events. To do so seems straightforward enough. Take

 eventA = _time (of event A)
 eventB = _time (of event B)
 TimeDifference = strftime((EpochTime(event A) - EpochTime(event B)) , "%H:%M:%S")

The time between events occurs pretty reliably every 30 minutes or so, as reflected in the logs. Yet, in my reports, I'm getting values like 30 hours. My first assumption would be that I mixed the Hours and Minutes up, but I haven't. Is there something wrong with my approach for finding the time difference? I am baffled.

Thanks for your time.

[sundareshr · Accepted solution]

Time difference is calculated as duration which is typically in seconds. So try this

TimeDifference = tostring((EpochTime(event A) - EpochTime(event B)) , "duration")

[_dave_b]

That works, i'm getting my expected value. Thanks!

I still don't see why strftime doesn't apply towards this, though.

[_dave_b]

Thanks for your reply. Why wouldn't strftime work? Seems like that should be the way to go according to the documentation.