Using one spreadsheet to create another tidier one.
 

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.

Using one spreadsheet to create another tidier one.
 

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

Jim Thomlinson


"Beth" wrote:

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.

Using one spreadsheet to create another tidier one.
 

I may be having a long day, but I'm not seeing a link....help?

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"Beth" wrote:

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.

Using one spreadsheet to create another tidier one.
 

This might help =)

http://www.contextures.com/excelfiles.html#Pivot
--
HTH...

Jim Thomlinson


"Beth" wrote:

I may be having a long day, but I'm not seeing a link....help?

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"Beth" wrote:

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.