Display difference between two dates into this format HH:MM:SS (08:00 to 18:00)

[Former Member]

Hi,

I want to show difference between two dates in HH:MM:SS, but in the range of 08:00 to 18:00 (business hours). If it is open before 08:00, consider 08:00 and finished after 18:00, consider 18:00. Monday to friday in business hours, if possible, don't count holiday.

I use SAP BUSINESS OBJECTS WEB INTELLIGENCE 4.1 SP 8

Please help

Thanks

[amitrathi239]

What is the data format in these two dates and data type of these objects?

[nscheaffer]

A blog post I just created will get you what you need provided you can determine the number of working days between two dates.

[Former Member]

Hi.

I only need the working days from 8am to 6pm, in this case, Monday to Friday. If possible, do not count the holidays.

Thanks

[Former Member]

Hi Marco,

Does the Holidays(Sunday's) needs to be included?