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 / Worksheet Functions / September 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
how do i find # hrs & mins. between 2 different dates and times13 Sep 2005 15:57 GMT3
In excel I have to keep start and finish times for different product
movements, I am constantly figuring the # of hours and mins. EXAMPLE  start  
date 8/12/2005 time 13:15, finish date 8/13/2005 time 05:35 equals 16 hrs and
20 minutes. Can excel figure this for me or am I out of ...
*HELP NOW PLEASE*13 Sep 2005 15:53 GMT2
need step by step instructions to extract data from column A starting with A1
and grab A4, A7, A10, A13, etc.
Signature

ALFR

Contains instead of Equal13 Sep 2005 15:43 GMT4
Is there a function that counts a cell if it contains a value rather than
equals that value?
For example, I'd like to count the number of cells that contain the word
"dog".
Multiple coin flips in a single cell13 Sep 2005 15:10 GMT7
I have three columns of data. The first column is the ID of a particular
Coin Flipper. The second is the number of coin flips each Coin Flipper
flips. The third column is the probability of each flipper flipping a
heads—these probabilities are different for each Flipper, but the ...
Help Needed Urgently13 Sep 2005 14:59 GMT2
I am woking on a spreadsheet and i need a running total on the hours worked
for by staff.
This is the way inwitch the data is set out.
08:30-21:00
Count "how many in a row"13 Sep 2005 14:57 GMT3
Is there anything I can do to get a cell to show how many times the sam
data is entered.
Example
1 A
Adding time Values up in Excel13 Sep 2005 14:55 GMT4
Im working on a Spreadsheet and i need the formula to work out the hours
worked.
The format of the way that the data is recived is for example 12:00-20:00 so
i need to to tell me that there has been 8 hours worked.
Creating Macro or Code Help?13 Sep 2005 14:29 GMT2
I have a user who is doing a repetitive action in a spreadsheet
and I'm wondering if there's a better way to do what she's doing. Let me
explain the process.
Sue has a folder that contains 250-300 *.PDF files that have a naming
How many std deviations is Excel function "STDEVP"13 Sep 2005 13:50 GMT4
How many std deviations is Excel function "STDEVP"
Subtotal results without word "Total"13 Sep 2005 13:47 GMT1
Excel Experts
When inserting Subtotals, isn't there a way to get the results without
having the word "Total" appended to each Totaled Item?
I knew this once.
format column for unique values only13 Sep 2005 13:06 GMT2
How can I format a column so that it only accepts unique values?
Thanks!
Signature

www.Marzetti.com

move from one column to another after a set condition13 Sep 2005 12:45 GMT4
i have a spread sheet 32 columns in length and if column b = paper then i
want the cursor to move to column h after i have entered details from column
a to column d and then if column b = book then i want the cursor to move to
column m and so forth.
Make a formula that adds every 4th cell in a column indefinately?13 Sep 2005 12:43 GMT3
In Office 2003 I need to make a formula that will add up every fourth cell in
a given column (i.e. A8,A12,A16,A20,etc). This range extends beyond 30
entries (one for each work day for a year) so entering each one individually
will not work. I haven't been able to find anything in ...
How do I stop Excel from treating blank cells as zero?13 Sep 2005 12:00 GMT2
I'm calculating the difference between two dates, such as
A1 - 1st September
B1 - 10th September
So B1-A1 returns 9, which is great.
Appending excel worksheets13 Sep 2005 11:57 GMT3
I have a huge number of comma delimited excel worksheets and need to copy or
append them into a single worksheet.  There are over 7000 records on some 300
worksheets, so doing a manual copy and paste would take a lot of time.
If I cannot do that in Excel, is there a way to do this ...
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New 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.