BusinessObjects Board

Using Time within calculations

There are two date variables which contain the date and time they were entered onto the database. From this I have set-up two variables which will show me the time only. I have then tried to subtract one from the other but BO wont comply. Is there a way around this?


ashley25 (BOB member since 2009-08-05)

Hi,

This old topic can help:


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

Excellent this worked!

HOWEVER, if the time is over 24hrs it has a β€œ-” before it. Is there a way of removing this?


ashley25 (BOB member since 2009-08-05)

Do you know how to sum & average the individual times? I have added a break so I would need to sum & average the the full block in the report and the individual ones?

Thanks


ashley25 (BOB member since 2009-08-05)