Math unforgives about paranthesis sometimes..


secs bigint;
plustime time;

secs = (checkout-checkin)*84000;
--integer delta as seconds.

days = secs/84000; -- number of full days

plustime = cast('00:00' as time) + (secs-(days*84000));
-- remainder time