|
how do u turn time into a number
i needed to calculate some hours from work and now that i am done it won't
let me turn my answer into a number. How do i do it?
total time 3:45
i want it to be 3.45 because i need to divide it by 2 and then multiply it
by 5
but when i put the formula it does not give me the right answer? can
someone help me? To understand what i am saying is that every 2 hours = 5
points but sinc...
|
8 |
12/8/2008 4:16:16 PM |
|
|
multiply
i have 3.75 in one cell and then in another cell i have =b2/2 and the answer
is 1.88.
i am trying to multiply it by 5 and when i do this i put =c2*5 and it gives
me the answer 9.375 and when i check my calculator it is wrong.
how can i get the right answer?
even when i put 1.88*5 it still gives me 9.375. what am i doing wrong?...
|
7 |
12/8/2008 4:10:20 PM |
|
|
Inserting a new worksheet that is linked to a previous one
Hello
I am trying to creat a template that a user can adapt each time and make it
as user friendly as possible. Each worksheet is one product and this template
will be used once a month for a different number of products.
There is worksheet A which contains summaries of the data from the other
worksheets. Worksheets B and C contain set formulas which are linked to the
summaries in w...
|
1 |
12/8/2008 4:04:00 PM |
|
|
setting multiple cells equal to other cells
I have a set of averages I've calculated. In another location on the
same worksheet, I need to essentially reorganize this info to be
displayed in another way. I was just copying and pasting the values
but realized if there was a change in my calculations for any reason,
I'd have to go back and recopy/paste as the cells wouldn't update. So
what I've been doing is simply setting these cells...
|
3 |
12/8/2008 3:33:53 PM |
|
|
Entering Military Time
I have a spreadsheet where I enter military time. I entered 24:00 and the
cell displayed 0:00. Is there a format I could use so the cell displays 24:00?
Any help would be greatly appreciated, Karen...
|
11 |
12/8/2008 3:21:02 PM |
|
|
ABS/IF formula
Hi,
i have a sheet, this follows the day of the week across the row and a
selection of devices going down the column:
mon tue wed thur
device1 10 11 15 18
device2 20 22 30 32
device3 22 25 26 28
on another sheet i need to work out the difference in time that the device
has been used, so for device1 between monday and tuesday it ...
|
7 |
12/8/2008 2:25:14 PM |
|
|
Using SUM function to count hours BUT ignore Letters?
Hi I use sum functions to total hours in rows and previously used coloured
cells for holidays, vacations and sick etc. (not ideal!) Ive started using
the IFCOUNT function to countr the number of holidays etc taken but the
problem I have now is the =SUM(cell:cell) formulas I have are giving errors
How can I make the SUM formulas ignore the letters?
thanks
Will....
|
7 |
12/8/2008 2:01:01 PM |
|
|
return a sum between two dates
I have data list with invoice details in it, invoice#, supplier, 12 or 13
digit code, cost, details etc. What I want to do is create a formula that
will return the total Cost of all invoces with code XYZ for the month of
january.
country site group code
700 441 5790 020 = Site x haz waste
700 203 5790 020 = Site y haz waste
700 44...
|
5 |
12/8/2008 1:32:13 PM |
|
|
Change Background Picture
I have made a calender in MS Excel, where I have insert a Picture in
background of the sheet. There has an option to choose year. Now I want that
the background picture will automatically change whenever change/choose year.
Is there any solution ? please help me & thanks in advance....
|
1 |
12/8/2008 12:30:01 PM |
|
|
If question
Cell S12 - =IF((A12)*(A12<>""),VLOOKUP(A12,'Books Borrowed'!$A$5:$G$35,3),"")
Cell A12 contains a value & In cell S12 i get the answer #N/A (I was
expecting this answer, there is nothing wrong)
However, since Cell A12 is not in the table array (From above formula)
'Books Borrowed'!$A$5:$G$35 (This is where i got the #N/A from) i do not want
that text to actually appear(Want t...
|
5 |
12/8/2008 9:19:11 AM |
|
|
If(not(A2="FL","AL".... ),"other",A2) IF(not help
Column A is a list of states. If column A is not 7 specific states, then i
want "other" if it is one of these states, then i want the state (ie A2 etc).
I'm trying to use If(not(.... but there are too many arguements. Any
suggestions would be greatly appreciated!!!
attempt:
If(not(A2="FL","AL".... ),"other",A2)
Then I am then using an Index Match function to find the pay rate...
|
4 |
12/8/2008 1:21:13 AM |
|
|
Gross taxation formula
Can someone show me the correct forumla to provide a net mothly figure
e.g
if a gross yearly wage figure is entered into A1 how can i show the tax paid
in A2 and the resulting nett monthly figure in A3
The formula has to work within the following thresholds:
0-$17,500 taxed at 12.5%
$17,501 - $40,000 taxed at 21%
$40,001 - $75,000.00 taxed at 33%
$75,001 and above taxed at 39%...
|
17 |
12/8/2008 12:59:41 AM |
|
|
how to hyperlink in a data valitation list?
Hello, I want to hyperlink in a validation list I have tried something that I
seen on youtube in "http://www.youtube.com/watch?v=p_77cZ1Vyl4" I did the
exact thing this person did and it didn't work, and when this person did it
on YOUTUBE it did work. There one diference he has Office 2007 and I Have
Office 2003 student edition that might be the resson that it dosen't work.
What I want ...
|
2 |
12/8/2008 12:58:00 AM |
|
|
Assigning a Number Based on a Range.
OOps. Guess my message got deleted in my last entry! I need to indicate if
a student's score is a level 1, a level 2, or a level 3 based on the number
of answers correct out of 22. Specifically, the scale is: 1-10 equals a
level 1; 11 - 17 equals a level 2; anything over 17 equals a level 3.
I have a lot of students! I have entered in column B the number of items
correct. In col...
|
5 |
12/8/2008 12:47:59 AM |
|
|
How to Count only visible filered cells "FP"
Is there a formula which will count only visible filtered cells which
equals "FP"?...
|
6 |
12/8/2008 12:41:36 AM |
|
|
Pivot Tables
I am venturing into the world of pivot talbes. Ultimately I would like the
report to be a table that essentially concatentates "n (%)", the number value
following by the percentage.
Currently, I have 2 pivot tables, they are identical except, one is the
count, the other is percentage. I do a paste special onto another worksheet
and from there, I can concatenate. This is a lot of work...
|
4 |
12/8/2008 12:16:28 AM |
|
|
Total when filtered
I want to get the total of the filtered cells only how do I do it?...
|
6 |
12/8/2008 12:13:29 AM |
|
|
If statements
NOT REALLY SURE HOW TO EXPLAIN IT, SO I THOUGHT IT MIGHT BE EASIER IF YOU
TYPE THIS IN A BLANK SPREAD SHEET
cell A1 type in - 08-Dec
cell B2 type in - 7
cell C1 type in - =A1+B1 (the answer is 15-Dec)
cell D1 type in - =IF(A1=0,"",C1) (the answer is 15-Dec)
cell E1 type in - =IF(D1=0,"",D1-TODAY())
(todays date is 7/12/2008 & the answer ...
|
2 |
12/7/2008 11:49:07 PM |
|
|
problem with if conditions
it seems the system will only allow a maximum of 8 conditions, is there
another way to have more conditions? Help would be appreciated.
M=IF(B32="clarifying project", "task 1",IF(B32="project initiated", "task
2",IF(B32="Project Initiated (On Hold)","task 3",IF(B32="Data
generation","task 4",IF(B32="Data Generation (On Hold)","task
5",IF(B32="PSCR Submitted","task 6",IF(B32="Data Req...
|
2 |
12/7/2008 11:10:45 PM |
|
|
Links Automatically refreshing in Excel 2007
I'm trying to find a way to stop linked documents being automatically
refreshed in Excel 2007. In 2003 you used to get a pop-up that prompted if
you wanted to update your links or not. 2007 doesn't do this and
automatically updates them. I have tried unticking the box for "update links
to other documents" but they still update.
I noticed in the Edit links section it has a bit for Upd...
|
4 |
12/8/2008 4:39:00 AM |
|
|
how to delete blank cells between those with entries
This is the set up. Column A has 2160 entries of daily data. Column B has
been created by averaging consecutive sets of 90 entries in Column A,
entering those averages on every 90th row of Column. I need to copy the
values in Column B and collapse them, by deleting the 89 blank cells between
each, at the same time. I know how to copy values as opposed to functions--i
have forgotten h...
|
2 |
12/8/2008 5:13:08 AM |
|
|
add time formula
I am trying to add these times and it keeps giving me 23:55 for total hours.
i know this is wrong can some one help me?
column a column b column c
7:30 PM 9:30 PM 2:00
8:45 PM 5:30 AM 8:45
8:15 PM 1:10 AM 4:55
8:15 PM 2:00 AM 5:45
8:15 PM 2:00 AM 5:45
8:15 PM 4:30 AM 8:15
8:15 PM 2:00 AM 5:45
23:55
this is ...
|
3 |
12/8/2008 9:16:13 AM |
|
|
Record deletion
I have 2 questions
1)
Is there any way to link a macro & cell together.
For example, i have a cell that has a kind of count down in days, updated
every day (open the spreadsheet today & its 10, open it the next day & its 9)
when the number within the cell reaches 0, it activates a macro that deletes
the entire row THAT the cell (that has 0 in it) is include within.
2)i have formulae f...
|
2 |
12/8/2008 2:05:01 PM |
|
|
First and Last Name Split in a cell
I'm trying to split the first and last names in a cell and have it appear it
two seperate cells so I can create some labels.
I've used this function in Excel in the '03 version and I can't seem to find
this formula in the '07 Excel version.
Can someone please help me. I know it was a pretty easy formula.
Thanks,
Karla ...
|
6 |
12/8/2008 3:29:06 PM |
|
|
use if statement in excel formula to populate adjacent from list?
Is it possible to create a formula using an if statement to populate an
adjacent cell from a list/dropdown of text?...
|
2 |
12/7/2008 9:08:59 PM |