Time difference between two columns

[system]

How to detect the seconds difference between two time values in Webi?

---

maajidabdul (BOB member since 2015-09-07)

[system]

120×120 10.4 KB

THIS May be the answer I have been looking for…or at least on the right track. I changed the names of the fields to match my fields. [Start Time] would replace [oldest time stamp] and [End Time] would replace [Newest Time Stamp]? Right? And if the time is labeled as a text column, how can I change it? It will not let me select any number options in the format cell menu. I have spent hours to get a duration, and finally found this forum, so I am really hoping you can help! THANK YOU!!! b…

like this

---

Antremons (BOB member since 2006-03-21)

[MarkP]

BO4.2 SP4 has introduce a new function called TimeBetween()

This caters for seconds.