How to calculate Business Hours in a Report

Question

Hello All,

I have a create_date column which is in date format. I need to calculate the SLA timings based on create_date column.

I must exclude saturday and sunday and consider business hours like 8 am to 6 pm.

I dont have time dimension and dont have rpd access to . I should do it report only.

please help

asim cholas · Answer

Hello,

Try below formula for finding SLA period. Also you can use dayofweek function if you need.

CASE  WHEN (Hour(create_date )+cast(MINUTE(create_date ) as double)/60 BETWEEN 8 AND 18) AND DAYNAME(create_date ) IN ('Fri', 'Mon', 'Thu', 'Tue', 'Wed') then 'SLA Window' else 'Non SLA Window' END

Thanks

Aj