Skip to Content
0

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

Jan 19, 2017 at 10:20 PM

63

avatar image

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

10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Venkatesh Katta Jan 20, 2017 at 06:48 AM
0

Hi Marco,

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

Share
10 |10000 characters needed characters left characters exceeded
Marco Túlio Calazans Jan 20, 2017 at 06:26 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded