Quote Originally Posted by SDCh View Post
Like daddylonglegs said: "Why isn't C10 = 15:00? ..."

here another way to get the time, base on your formula:
=IF(B10<A10,IF(A10>TIME(18,0,0),1-A10+B10,(1+B10-TIME(18,0,0))),MAX(0,B10-TIME(18,0,0)))
Regards,
SDCh

That worked just as well!

Thanks!