How to identify time difference between two datetime fields

[system]

I have 2 datetime fields that I am trying to identify the difference in time between (minutes difference).

It seems as though many poeple have tried to do this, but there doesn’t apear to be a solution in the report.

I can not achieve this in the universe, so need a solution in the report. Can someone please help?

Ideally the answer would be just as number of minutes difference in total between 2 datetimes.

---

lidsurfer (BOB member since 2013-05-20)

[system]

Welcome to B:bob:B!

This old post can help:

Diff between two dates

I am trying to create a variable in Desktop Intelligence XI that will give me the diff between two dates. I used “=DaysBetween(<Admit Date & Time> ,<Order Date & Time>)” and I get just days. Is there a way to get his broke down to hours, minutes and seconds? djohnson (BOB member since 2007-07-26)

The formula there is for DeskI so you will need to re-write it for WebI but that should not be difficult.

---

Marek Chladny (BOB member since 2003-11-27)