I'll assume you have a very small group of clients. So you can set everything
on one worksheet.

First establish a table of customers and the time they start with each month
on the left side of the worksheet. For the sake of example I will start this
table in column G. In column G put the client name, and in column H put the
number of hours. Call the range "Timeblock" (or whatever).

To the right in the spreadsheet set up something like the following for your
daily transactions.
Col A - Client
Col B - Date
Col C - Start
Col D - End
Col E - Time

Col E is equal to Col D - Col C.

Enter in one transaction per line.

In cell Ix enter in vlookup (Gx,Timeblock,2) - sumif (A:A,Gx,E:E) where x is
the row and duplicate this formula for each client in column G. Column I will
track time remaining.

You can also use column G to validate the names entered in column A in a
dropdown list.

"ultra_xcyter" wrote:


I am trying to keep track of how much time my client uses per month.
They have purchased 10 hours of consulting time per month and I need to
keep track of their usage. I am trying to setup a spreadsheet where I
can enter the start time and end time for various projects that I do
for the client, and have this time automatically subtracted from the
total time, which is 10 hours per month. How can this be done? Thank
you in advance for your tips.


--
ultra_xcyter
------------------------------------------------------------------------
ultra_xcyter's Profile: http://www.excelforum.com/member.php...fo&userid=9946
View this thread: http://www.excelforum.com/showthread...hreadid=535061