BM1.xlsx [https://filedb.experts-exchange.com/incoming/2011/08_w32/486156/BM1.xlsx]

BM1.xlsx

Q-27240979.xlsm

<div>
Thank you.<br />
<br />
How can I determine best time of day when 'actions' occur?<br />
<br />
Thank you.
</div>


Thank you.

How can I determine best time of day when 'actions' occur?

Thank you.

<div>
faithless1,<br />
<br />
Depends on what you mean by &quot;best&quot;.<br />
<br />
The approach I outlined can help you identify when they occur. &nbsp;WHether or not they occur at the best times, well, I have no way of knowing.<br />
<br />
Patrick
</div>


faithless1,

Depends on what you mean by "best".

The approach I outlined can help you identify when they occur.  WHether or not they occur at the best times, well, I have no way of knowing.

Patrick

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I need some help with analyzing attached data. The spreadsheet includes time and day of occurrences. <br />
<br />
I need to figure out which days and time occurrences are most likely to happen. Days and time can be separate data sets.<br />
<br />
Thank you 
</div>
</div>


Hello,

I need some help with analyzing attached data. The spreadsheet includes time and day of occurrences. 

I need to figure out which days and time occurrences are most likely to happen. Days and time can be separate data sets.

Thank you 

Pivot Table / Graph

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