For Ex Time spent on Deliver block activity. I am using below formula

DATEDIFF ( HH, PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (Set Delivery Block, Set Default Delivery Block)),

PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN IN (Remove Delivery Block)) )

But this formula will consider weekend and holiday hours as well.

Please let me know how to get the working hours only .

I have tried below formula as well after looking at

Using workdays_between without a dedicated calendar table Codes & Statements

Hi guys,

my problem ist actually quite simple. I want to calculate the number of workdays (monday till friday) between two given timestamps. The relevant function requires me to reference a specific calendar table from the data model. Within the data model options, however, the possiblity exists to define a custom calendar without implementing a dedicated table (simply by selecting relevant days and time windows). My questions is: How do I reference this adjusted standard calendar as a paramete

as i dont have any calender table to use.But Below formula is also not working.

CALC_THROUGHPUT(FIRST_OCCURRENCE[Set Delivery Block] TO LAST_OCCURRENCE[Remove Delivery Block], REMAP_TIMESTAMPS("_CEL_O2C_ACTIVITIES".EVENTTIME, MONDAY 08:00-17:00 TUESDAY 08:00-17:00 WEDNESDAY 08:00-17:00 THURSDAY 08:00-17:00 FRIDAY 08:00-17:00 ),

REMAP_VALUES("_CEL_O2C_ACTIVITIES".ACTIVITY_EN, [Set Default Delivery Block, Set Delivery Block])

)