SLA/Turnaround Time

[Melissa]

Hi @BI_Noob_Forgiveme,

I think you’ll find what you need in this thread.

Time format 37:30:55 greater than 24 hours

. Okay so Bill Szysz created a Power Query M function that does just that and here it is: (WHStart, WHEnd, Start, End, ListOfHolidays) => let DStart = Number.From(DateTime.Date(Start)), // start day TStart = Number.From(DateTime.Time(Start)), // start time DEnd = Number.From(DateTime.Date(End)), // end day TEnd = Number.From(DateTime.Time(End)), // end time // List of days without saturdays and sundays ListOfNumbe…

.
If you need further assitance please provide mock up data and PBIX, thanks
In the Reply window, you can use this icon to upload a file.

I hope this is helpful.