I want to do calculation between date/time fields

building reports webintelligence
1

Hi,

I already post this question a couple of times but I can’t make it work. I have posted two attachment in this topic.

Attachment “Example1” is the webintelligence rapport. I have converted a date/time field to a field so i can make calculation on it but i don’t know ho to convert it to minuts;seconds.

Attachment “Example2” is the thing I want, if i make this calculation in Excel it’s very simple and works perfect. I want this in my Webintelligence report but don’t know which functions/script i need to have.

Thanks again;
example2.JPG
example1.JPG

fmonsma (BOB member since 2007-07-30)

2

Hi there,

I use this formula to convert a decimal time into hours and minutes:

=FormatNumber(Abs([Decimal Time]-Mod([Decimal Time];1));“0”)+":"+FormatNumber(Mod(Abs([Decimal Time]);1)*60;“00”)

Hope this can help…

Grtz,
Filip.

filip :belgium: (BOB member since 2005-12-29)

3

:? :? :?

Moderator note:
Please do not cross-post. It leads to fragmented discussions and is against our forum rules. Please, next time do not open a new thread, continue posting in your original thread instead. I locked all the other threads opened by you :? Thank you.

Andreas :de: (BOB member since 2002-06-20)

4

Hi, I’m using the dutch version of Business Objects, if i translate this to the dutch variables it doesn’t work. I says i’m missing a " or something like that?

fmonsma (BOB member since 2007-07-30)

5

This is the dutch version, works fine:

=NotatieNummer(Abs([Tijd]-Rest([Tijd];1));"0")+":"+NotatieNummer(Rest(Abs([Tijd]);1)*60;"00")

Note that this formula converts to hours and minutes, not minutes and seconds as you request. So it needs some adjustements…

filip :belgium: (BOB member since 2005-12-29)