More problems displaying a negative time

[SheriffCassidy]

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!!

 

[JE McGimpsey]

Since XL stores times as fractional days, 16:58 = 16:58/24:00 =
0.706944444.

So choose

Format/Cells/Number/Custom [<=0.707291666667]hh:mm;[Red]hh:mm

(the number in brackets being approximately halfway between 16:58 and
16:59).