BusinessObjects Board

Number of Hours calculation


Can anyone please let me know, how to calculate the time difference in Hrs from two dates in webi XI R2/R3.

For example, if we have two date fields like Start date and End date.
Start Date: 08/19/2010 10:15:05
End Date: 08/19/2010 11:15:05

How can i calculate the difference in these two dates in Hrs. I guess Days between function wont work here.


sumanreddy (BOB member since 2008-08-05)

In universe create two objects for hours

Hours1 to_number(TO_CHAR(DATE1,‘HH’))
Hours2 to_number(TO_CHAR(DATE2,‘HH’))

patriot3029 :india: (BOB member since 2006-12-08)


This can get you started:

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