can I chart time sheets like this?

[legalcat]

I need to create a database with about 250 time entries, the entries are like this:

Date, User, Activity Description, Activity Type, Time (using 1/10ths of an hour)

2/5/11, Jane, Read Email from Mark, Email, .1
2/6/11, Mark, Create email to Jane, Email, .2
2/7/11, Jane, Review spreadsheet, Review, .5
2/7/11, Mark, Review spreadsheet, Review, .5


Is it possible to then chart that data to show the following:

1 chart which shows how much time Jane spent versus how much time Mark spent on ALL activities so it would show 50% Jane and 50% Mark

1 chart which shows how much time was spent on email activity versus review activity so it would show .3 portion of time for email and 1.0 portion of time for review

and perhaps a bar chart showing activity per day for all users ?

[arthurbr]

Hi and welcome to the board.

Please have a look at forum rules before posting any further

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.