Issue in Excel with time difference

Hi guys,

I have put together a spreadsheet and one of my columns works out the time difference between two cells.

Some of the cells work fine, however some of them simply show #############, which appears to be due to column B having a higher time than column C:

Excel time issue.JPG

Is there any way to deal with this?


Many thanks,

Chris

Try

=MOD(C1-B1,1)