Q
quattda
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
L9)<>0,COUNT(D9L9)=COUNT(D8L8)),$B$2-(SUM(D9L9)-SUM(D8L8)),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?
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
L9)<>0,COUNT(D9L9)=COUNT(D8L8)),$B$2-(SUM(D9L9)-SUM(D8L8)),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?