Need to calculate occurrence of cells with zero value, over day & hour. Also need to find occurrence of values which are greater than zero.
Data are values in minute by minute and over 30 dates period, if needed hour formula column can be added if minutes cannot be converted into hour.
have attached file with expected result.
Thanks
Bookmarks