Thanks for your response but this formla seems to return
a fixed value of 22:00. Am I doing something wrong?

=Min(D24,time(44,0,0))

and format as time