Hi
try for the first one
=(C1<B1)+C1-B1

--
Regards
Frank Kabel
Frankfurt, Germany

Jonsson wrote:
Hi all,

Is there a way to write 10 a´clock PM as 2200 in cell B1 and 7
a´clock AM as 0700 in cell C1, and get the correct value 9 hours in
cell D1?

And/Or.....

color 9 cells, (just as the number of hours), and get the time value
2200 and 0700.

I hope there is........

Thanks for any help

//Thomas