Daily summary in one cell

[cpliu]

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,

 

[Don Guillett]

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