I have to make a spreadsheet for the first time. I have been paid for
a project, and I have to keep a timesheet in minutes, which works best
for this project. The time I’ve been paid for comes to 4,590 minutes.
I will have 4 columns: date in A, description of specific task in B, #
of minutes for that specific task in C, and current balance of minutes
used in D.
So I start with 4590 in row 1 column D, and my first task entry is 45
minutes, which I enter in row 2 column C.
Question One: how do I set up C and D so that when I enter 45 in row 2
coumn C, row 2 column D will automatically show a balance of 4545?
Question Two: how can I eliminate columns E and following, so that only
the four columns show?
thanks so much!
carlo - 11 Dec 2007 01:47 GMT
For your first question,
enter following formula in D2:
=if(C2="","",D1-C2)
then you can copy it down
(which means, that you can select D2 and then copy the formula
down by dragging on the lower rigth corner of the cell)
concerning your other question look at this post:
http://groups.google.com/group/microsoft.public.excel.worksheet.functions/browse
_thread/thread/5c1ee7b0174a90f4/3dd73267b49c40c8#3dd73267b49c40c8
hth
Carlo
> I have to make a spreadsheet for the first time. I have been paid for
> a project, and I have to keep a timesheet in minutes, which works best
[quoted text clipped - 14 lines]
>
> thanks so much!
Bob Phillips - 11 Dec 2007 08:56 GMT
D2: = C1-C2
and copy down
Select columns E:IV, then Format>Columns>Hide.

Signature
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
>I have to make a spreadsheet for the first time. I have been paid for a
>project, and I have to keep a timesheet in minutes, which works best for
[quoted text clipped - 14 lines]
>
> thanks so much!