<div>
create a pivot table on your raw data and add a filter on count to exclude 0's
</div>


create a pivot table on your raw data and add a filter on count to exclude 0's

<div>
<div class="content wysiwyg-content">
I have excel list, which I have times and totals. What I'm looking to do is create a formula that will go down the list and &nbsp;and as long as there are hours list the time and the amount.<br />
like 12:00 am &nbsp; &nbsp; &nbsp;11<br />
12:30 &nbsp; &nbsp;14<br />
Won't list 1:00 am because the count is 0. <br />
Any thought on this?<br />
12:00:00 AM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;11<br />
12:30:00 AM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;9<br />
1:00:00 AM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0<br />
1:30:00 AM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;7<br />
2:00:00 AM &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3<br />

</div>
</div>


I have excel list, which I have times and totals. What I'm looking to do is create a formula that will go down the list and  and as long as there are hours list the time and the amount.
like 12:00 am      11
12:30    14
Won't list 1:00 am because the count is 0. 
Any thought on this?
12:00:00 AM	11
12:30:00 AM	9
1:00:00 AM	0
1:30:00 AM	7
2:00:00 AM	3


excel list if = 0 then don't add to list

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.