software

I need a formula that does this.
Between 8:00 AM and 9:00 AM John Smith completed XX tasks. Between 9:00 AM
and 10:00 AM he did XX tasks. The information i have looks like this:
Col A Col B
John Smith 2/03/2006 9:12 AM
John Smith 2/03/2006 9:47 AM
Jane Doe 2/03/2006 9:22 AM
John Smith 2/03/2006 10:01 AM

Final result should be like this:

Employee 8 - 9am 9-10am 10-11am

John Smith 2 4 4
Jane Doe 2 3 4

Any thoughts? I can not access other web sites due to company security so
no links please.
Thanks
--
Robert

Did my suggestion yesterday not work? Because you should be able to add Col
C with this formula: =HOUR(B1) which will give you the hour the task was
finished.

Then, on a separate page, insert a Pivot Table (Data | Pivot Table). Your
data range will be columns A through C on Sheet1. In your layout view
(PivotTable Step 3 of 3 | Layout), drag the Employee column into the quot;Rowquot;
area, drag the quot;Hourquot; column into the quot;Columnquot; area, and drag the quot;Hourquot;
column into the quot;Dataquot; area (where it will default to quot;Countquot;, which is what
you want). Select quot;Okquot;, then select quot;Finishquot; and you'll have a chart that
does exactly what you want.

If you want fancy headings (like quot;8-9amquot;), format Col D on Sheet1 with:
=C2amp;quot;-quot;amp;(C2 1) and use that quot;Timequot; column in your Pivot Table instead of the
Hour column.

Let me know if this isn't enough information.

quot;Robertquot; wrote:

gt; I need a formula that does this.
gt; Between 8:00 AM and 9:00 AM John Smith completed XX tasks. Between 9:00 AM
gt; and 10:00 AM he did XX tasks. The information i have looks like this:
gt; Col A Col B
gt; John Smith 2/03/2006 9:12 AM
gt; John Smith 2/03/2006 9:47 AM
gt; Jane Doe 2/03/2006 9:22 AM
gt; John Smith 2/03/2006 10:01 AM
gt;
gt; Final result should be like this:
gt;
gt; Employee 8 - 9am 9-10am 10-11am
gt;
gt; John Smith 2 4 4
gt; Jane Doe 2 3 4
gt;
gt; Any thoughts? I can not access other web sites due to company security so
gt; no links please.
gt; Thanks
gt; --
gt; Robert