See Peo's response.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Good Time" wrote in message
...
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