Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 20, 2017 at 06:48 AM

    Hi Marco,

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 20, 2017 at 06:26 PM

    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

    Add comment
    10|10000 characters needed characters exceeded