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