Home |
Search |
Today's Posts |
#1
|
|||
|
|||
More problems displaying a negative time
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!! |
#2
|
|||
|
|||
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). In article , "SheriffCassidy" wrote: 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you enter a negative time number in Excel? | Excel Discussion (Misc queries) | |||
Calculating negative time & creating scrol bars for fixed size txt box. | Excel Discussion (Misc queries) | |||
time and date problems still | Excel Worksheet Functions | |||
negative time | Excel Discussion (Misc queries) | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) |