Can anyone help me with what I am sure is a very simple solution! I need to
produce a timesheet that shows time in hours and minutes but can be added to
or subtracted - with the results still showing minutes. Therefore, I don't
want to put in decimals .... how do I do this please?
Thank you!
Carol
My dear friends & respected ones,
warm regards to everybody.
I am new to this forum. My query is :Is there any operator or function in MS Excel to reverse the bit pattern of a binary no. as we perform in Boolean mathematics.
Eg. Suppose there is any binary no. in cell A5 as "111011110101", so by using any operator, how inverted binary no. i.e. "000100001010" can be obtained.
Also are there other operators so as to perform AND, OR, EX-OR operations of digital electronics?
Best Regards,
-------------
Aashu
Hi
What I want to achieve:
To select a range of rows to be copied to another sheet based on dates
entered by the user. For example: All rows with dates between 20/12/2007
and 25/12/2007. The user adds these dates to a cell in another sheet.
I started off trying to use:
Code:
Columns("B:B").Select
ActiveSheet.Range("$A$1:$AS$501").AutoFilter Field:=2, _
Criteria1:=" & >= Date1 & ", Operator:=xlAnd, Criteria2:="= &
I have created a worksheet for the purpose of date tracking. The problem
that I have is that 1/14/1900 is displayed after I create a formula.
Example; the formula is a2=a1+14. When there is no date listed in a1
1/14/1900 is displayed. I do not want to see this. When I tried to hide
this, I was unable to see anything. Is it possible to hide this particular
problem?
Thanks in advance for any help with this matter.
I've recently been upgraded to excel 2003 and when I open a file I'd been
working on in excel 97 any formula entered has the result '0'. Even if I go
to a blank cell and type '=1+1' the answer is still 0.
Any ideas anyone?
Guys,
If I in a cell type a formala like +(5/12)*A5, how can I make the formula remain like this, rather than being changed to +0,4166667*A5? I find it handy to keep the sub-calculations in the formulas (to be reminded of the underlying "logic", or when sharing with other users), but to me it seems random whether or nor they are kept or "calculated". Have so far not found a format option for this. Would love to get advice. Thanks a lot.
Ok I have the formulas changed on my worksheet and they stay static when I add a column. But now the calculations are wrong.
=((INDIRECT("I8")-INDIRECT("J8")/INDIRECT("J8")))
I8 = 149
J8 - 149
and it's coming out 14800%.
Can anyone see what I'm doing wrong?
Hi everyone, first thanks for the help.
I am trying to create a histogram and let me explain some of the data.
I have a list of data separated like so:
3.5
3.6
3.8
3.8
3.9
3.9
etc...
Now I need to calculate the frequencies of these like so:
3.5 (up to but not including) 4.0
4.0 (up to but not including) 4.5
I can count out the frequencies myself but i need to create a histogram (bar graph) with the y axis as the frequency and the x axis as the IMR(infant mortality rate: ie the 3.5 (up to but not including) 4.0).
I am having problems with calculating the frequencies because when setting the bin values because they include 4.0.
If this is confusing I can provide some more information, but cannot find a good tutorial that would create a histogram anywhere remotely close to the histogram i drew by hand.
