Using one spreadsheet to create another tidier one.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to keep track of the time spent on particular projects for billing. So
I have a simple spreadsheet with the date, project name, and time spent that
gets filled out daily.

I need to take that data and turn it into a pretty spreadsheet billing can
understand. I'd like to have one row for each project, date completed and
total time spent.

So I'm trying to tell the total time spent cell of a particular project to
go to the simple spreadsheet, find all the rows with that project name, and
add up the total times.

is this even possible, or am I living in a fantasy land?

Thanks.
 
Take a look at this link. There is a download for employee time tracking that
might give you some ideas to get you going.
 
Back
Top