I use Excel for project management. I have a column with project names, onecolumn with tasks involved, one column with time used for each task and project, and another with dates. I'd like to have a summary that would show the project names, time used for each. How can I do that?

For example:
column A, column B
2/1/2011, project a: 1.5, project b: 2.5, project c: 3.0

Thanks for the help,

On Feb 2, 7:17*am, cpliu <spamfree...@yahoo.com> wrote:
> I use Excel for project management. I have a column with project names, one column with tasks involved, one column with time used for each task and project, and another with dates. I'd like to have a summary that would showthe project names, time used for each. How can I do that?
>
> For example:
> column A, column B
> 2/1/2011, project a: 1.5, project b: 2.5, project c: 3.0
>
> Thanks for the help,

More detail on layout or send file to dguillett1 @gmail.com