S

#### stainless

For example, cell B2 is [h]:mm containing the value 39:00. I want C2 to show 2:00 i.e. subtract 37 hours

Likewise, if B2 is 24:00, I want C2 to show -13:00, using the same subtraction method.

I have been unable so far to get either the formula right or indeed the format of C2, although I did assume this format would be also [h]:mm.

Any ideas?