Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / December 2007

Tip: Looking for answers? Try searching our database.

Excel 2000 Newbie Questions

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
sherlock62 - 11 Dec 2007 01:39 GMT
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!

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.