BusinessObjects Board

Hours Minutes Difference

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.


nivas258 (BOB member since 2008-04-14)

Are they always the same day?

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)


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

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