Hi, Is there a way to get the end of business hours for a day from a calend

There's not a function that does exactly that as far as I know, but you can get close using the out-of-the-box functionality with something like the expression below. It's not particularly nice but it returns an array of 24 booleans that equate to the 0-23 hours of the given date, where the true/false value of each index indicates whether or not it's a working day. It would be possible to expand on this down to the minute with a little more work.

apply(
fn!calisworktime,
apply(
fn!datetime(
year(
ri!date
),
month(
ri!date
),
day(
ri!date
),
_,
0,
0,
0
),
enumerate(
24
)
)
)

I should add that the array is still 1-indexed, so index 9 = 8am, and for your use case you'd want to find the last index that is true, so you'd wrap this function in where() and max() to get the highest index that is true. You'd also probably want to take into account timezones when doing this.

Also where i say "whether or not it's a working day" up there, I meant "working hour"

Thanks @philb.