I have some reports that show when a ticket was opened and when the ticket was resolved. It´s possible to know the working hours between the open date and the resolve date? My intention is to remove the weekends and account only the workshiftof the teams .
A ticket was opened on 6/12/15 ( friday ) at 05:00 pm , and was solved on 6/15/15 ( monday ) at 10:00 am . It is known that the workshift of the teams is from 08:00 am until 8:00 pm , then the due time of this call is 5 hours (3 hours on 6/15 and 2 hours on 6/15 ) .
Can I calculate this working hours within the Business Objects ?
Thank you .