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 has
a value of 1:15, when the bar chart is created there is no value displayed in
the chart.

Any suggestions about what might happening?