Have you tried using TIMESTAMP_DIFF?
TIME doesn't contain a day portion, so differences over 24 hours would likely not work.