hi,

I am using a formula to determine how many hours have been worked between times
using colons
i.e 14:00 to 16:00

14:00 is (C8-INT(C8))*24
16:00 is (D8-INT(D8))*24

Then I've =D8-C8 in another column to give me a total hours worked

this works fine but when I get to using 0:00 for midnight the figures go wrong and I get a negative figure

in the above example I would get -14.00

how do I combat this please??