Hi,

A1 and B1 are times using 24 hour clock and format of [hh]:mm
So my problem is when I have 18:00 and try to take away 17:00, it returns a zero, if I Input 17:00 and take away 16:00 it works fine, something about 18:00 and a one hour gap is tripping it up.

Thanks for the interest.