Hi I have a chart which calculates segment time differences for a TV prgram
which consists of short segments that make up the overall program.

For example the program starts at 14:00:00 and must be finished by 16:58:00.
I am inserting and removing segments inside the timefame and my formula in
question is a simple one to display whether we are under or over the time
allowed. "=ABS(H11-H12)" :where H11 is 16:58:00 and H12 is the sum of all the
segment program durations.

Problem is, this formala shows the result as an identical result for both
negative and postive results. I would like to see the result as black for
less than 16:58:00 and either red for over 16:58:00 or with a minus sign. It
must be displayed in time format. This is essential.

Thanks in advance!!