Difference between two dates into hours in webi

[Former Member]

I have requirement of calculating difference between two dates in hours. I tried using Daysbetween function it is giving me only days between the the dates. But it is not calculating hours difference.

Ex:

I have two dates:

Start Date:

05/01/2018 10:10:00 AM

Submit Date:

05/01/2018 04:00:00 PM

I have to implement this in webi.

Can anybody give me formula for this one.

Thank you!!

[amitrathi239]

follow attached thread.First you need to use right function to get the time part only. right ([Object];11).After that follow link.

http://www.forumtopics.com/busobj/viewtopic.php?p=895382