Subtracting Time - Is this possible?

Originally Posted by Richard Buttrey

=C4-B4+IF(B4>C4,24)

If C4 and B4 are time values then that formula will potentially give you an incorrect result beacuse 24 represents 24 days, e.g. B4 = 22:00, C4 = 02:00, custom format result cell as [h]:mm and you get 556:00, 24 should be 1