Hours Minutes Difference

[system]

Hi All,

I have two date fields with the format MM/dd/yyyy hh:mm:ss

I want to find difference between these two dates and display in hh:mm format. Can someone please help me to achieve this.

Thanks

---

nivas258 (BOB member since 2008-04-14)

[MarkP]

Are they always the same day?

[system]

My system isn’t up to give the exact code, but conceptually this will work

Normalize the two timestamps to minutes.

#Minutes = [Years * (365 * 24* 60)] + [JulianDate (date) * 24 * 60] + [Hour * 60] + Minutes

Do this for both the timestamps and then determine the delta. This is the number of minutes between the two events. If you divide by 60 you will get the number of hours with a remainder of minutes.

You can then convert this back to hh:mm

Make sense?

---

BBfromUD (BOB member since 2012-05-07)

[system]

Hi,

This old topic can give you an idea how to write the formula for your calculation:

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)