Time Calculations;olour of the celL

[cobalt01]

Hi, I would like to calculate the difference in time. The problem is I want the time to show has a plus or minus figure but in the format off 0.10 or -1.30 etc. An example would be:

Cell 1 Cell 2 Cell 3
23:00 00:09 1:09

Cell 1 Cell 2 Cell 3
00:04 00:02 -00:02

I can get it to work with two calculations but I want it to work in the same one and the colour of the cell to change colour if the value is between or less than a time which I know how to do

Thanks Neil

[JapanDave]

Post a sample file of what you are trying to do.

[cobalt01]

Here is a example thanks.