Variable help - Hours between 2 dates

[system]

Hi there

I’m really struggling with the following variable.

I want to calculate the hours between 2 dates. PLease see attached. Can anyone help me with this variable…please!!

I look forward to hearing from you.

Kind regards
Karen
(3) 48hrs CV Submittance.xls (38.0 KB)

---

karenfingerhut (BOB member since 2010-02-18)

[system]

Hi Karen,

Formulas in this old topic can get you started:

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)

---

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

[system]

Many thanks for this. I’ll take a look and let you know how I get on.

Thanks and kind regards
Karen

---

karenfingerhut (BOB member since 2010-02-18)