K

#### Kiaat

If, for instance, in Excel you write 17:00 - 16:30, it will produc

0:30. However, 16:30 - 17:00 will produce #####, understandibly

because you cannot have - ? o'clock. By formatting this to a number

can produce -0.5.

What if I still want to represent the decimal, but out of 60, so that

can still get -0.30. I have tried messing about with fractions and

still can't get it. Any ideas?

Thanks,