| Thread | Last Post | Replies |
|
| how do i find # hrs & mins. between 2 different dates and times | 13 Sep 2005 15:57 GMT | 3 |
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 GMT | 2 |
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 Equal | 13 Sep 2005 15:43 GMT | 4 |
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 cell | 13 Sep 2005 15:10 GMT | 7 |
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 headsthese probabilities are different for each Flipper, but the ...
|
| Help Needed Urgently | 13 Sep 2005 14:59 GMT | 2 |
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 GMT | 3 |
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 Excel | 13 Sep 2005 14:55 GMT | 4 |
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 GMT | 2 |
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 GMT | 4 |
How many std deviations is Excel function "STDEVP"
|
| Subtotal results without word "Total" | 13 Sep 2005 13:47 GMT | 1 |
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 only | 13 Sep 2005 13:06 GMT | 2 |
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 condition | 13 Sep 2005 12:45 GMT | 4 |
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 GMT | 3 |
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 GMT | 2 |
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 worksheets | 13 Sep 2005 11:57 GMT | 3 |
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 ...
|