I am trying to create a bar chart that refers to a set of cells which are
calculating the remaining time after subtracting the differences between
beginning and end times from a static time value (1:15) using the following
formula:
=IF(AND(COUNT(D9:DL9)<0,COUNT(D9:DL9)=COUNT(D8:DL 8)),$B$2-(SUM(D9:DL9)-SUM(D8:DL8)),B2)
The B2 cell refers to the static time of 1:15 that is formated as h:mm. If
there is no start and end time values in the range and therefore the cell is
assigned a IF-FALSE value of 1:15, when the bar chart is created there is no
bar value displayed in the chart. If there are start and end time values in
the range, a correct time value is represented as a bar.

Any suggestions about what might happening?