One spreadsheet but adding hours on a client by client basis..

[arthurArthur]

Hello,

Because I have the need to keep a running total of how long I have spent on each of my clients during the month and during the year I would like to be able to add 2 columns on the end of my time sheet.

This way at a glance just by scanning to the right I can see how much time has already been used..

I would like to quickly be able to answer the question, how much time did you spend in 2012 on X client's project work? Or how much time was spent on Y last month.?

This is a simplified structure:

Col A = Date
Col B = Client Name
Col C = Item Hours
Col D = Client Total Month – New Col
Col E = Client Total Year – New Col

Date	Client	Item Hours	Client Total Month	Client Total Year
1st Jan 2012	X	1h	3h (Jan)	21h
12th Jan 2012	X	2h	3h (Jan)	21h
4th April 2012	Y	4h	4h (April)	4h
11th June 2012	Z	2h	2h (June)	11h
9th Nov 2012	X	7h	9h (Nov)	21h
22nd Nov 2012	X	2h	9h (Nov)	21h
12th Dec 2012	X	9h	9h (Dec)	21h
15th Dec 2012	Z	9h	9h (Dec)	11h

Many many thanks in advance, so far I have been unable to use Excel correctly to make this happen... I think my 'subtotal function' tag is sensible, but am not sure..