I need information on how to enter the proper syntax (formula) so that excel

can calculate overtime hours. In california over 8 hrs in one day is

overtime. The 8 would be considered regular hours and anything over is OT.

can calculate overtime hours. In california over 8 hrs in one day is

overtime. The 8 would be considered regular hours and anything over is OT.

- How to calculate surface area in excel chart
- HOW TO: Create Functions to Calculate Light Years in Excel 2000
- How to solve the equation in excel using exp(x)
- How to create a crosstab in Excel
- How to write a marco in Excel to delete worksheet?
- How to capture user ID in Excel macro?
- How to execute sql script in excel?
- How to get column properties in excel??
- How to stop opening outlook in excel
- How to copy a cell in excell and paste in a txt file with macro
- How to creat a sheet in Excel when the sheetname include space?
- How to give escape sequence in Excel string literals...
- How to make a game in Excel???
- How to set GUID function in Excel?
- How to create pie chart in Excel2003 using c#
- Join arrays in Excel
- How to calculate overtime automatically on Excel timesheets
- How to calculate the data in excel 2002 including only the last 9.
- How to calculate Equations in Excel.
- Answer:How do I calculate # of weeks between 2 dates in excel?
- how to new(Updated) Sql Data import in excel using vba
- How to calculate interpolated value in a table?
- How to program dependent list in Excel using VBA?
- Help!!! How to delete 2500 rows in excel with formula?

different lines and i have no idea how to do it so if anyone can help me with

it...thanks

--

k

This article explains how to create custom functions to make these calculations. Back to the top. Example Calculations The following formulas give the conversion rate between miles and ...

pls help cause its quite important to me

I have a simple spreadsheet that looks like this:

Origin State Dest State Company

AL AL A

AL AR A

AL AZ B

AZ AL A

AZ AR C

....and so on. Basically, the first 2 columns have all states/provinces and

column 3 has the company we use. I need to create one matrix with all

states/provinces in Row 1 and in Column 1, and all the cells in between are

populated with the company.

Question is How can I do this using MS Excel using Pivot Table. I can do this using Business Objects or Crosstab Query in MS Access but how do I do it in Excel using Pivot Table? This can be done by using INDIRECT and MATCH functions but this involves a couple of steps. Is there any shorter method?

I have attached an excel sheet that gives what I have, What I can do using Access or Business Objects and what I get using Pivot Table in Excel. The normal Pivot Table in Excel gives numbers instead of the company name even if I use Max or Min function (which works fine in MS Access query). So what am I missing here?

Thanks in anticipation,

Warm Regards,

Kallol

Do you know how to write a marco in Excel to delete worksheet automatically, without prompting me to click OK?

I have tried one by using the command:

Sheets("Sheet2").Delete

but it will ask me to click OK before delete it. It looks not professional.

Thanks a lot.

I have an Excel macro program which uses ADO connection. It connects to our

AS/400 database. When the program connects to the AS/400 system for the first

time after the program is opened, it prompts a AS/400 login dialogue box and

then the user keys in his/her user name and password. If I want to capture

the user name from the AS/400 login dialogue box, then how to do it? How to

write the code in Excel macro? Is it possible?

Thanks in advance!

Ivan

I need some ideas on how to execute this Scripts in excel automatically.

Right now it is working, if I select all contents of Scripts sheet and paste in the Query Analyzer (Manual process).

I was trying to save this sheet as text document, but somehow it is not working with the options (Unicode, DOS, space delimited).

Any ideas would be appreciated.

Thanks,

Carlos

namely 1. Value Format, 2. Column Format, 3. Data format and 4. Conditional

format. The main thing I am looking at is "Custom CSS Options (HTML Only)

check box.

How to stop opening outlook in excel when clicking into a cell that contains

an email address.

an email address.

Could you please tell me how to create a sheet in Excel when the sheetname include space?

like the sample below:

Create Table [as test one] (column1 int, column2 ...)

I just want to create a sheet in a excel table, and there should be spaces in the sheet name, like "as test one". I try to send the sql above and get a new sheet with the name like "as_test_one". But I hope I can get the sheet name like "as test one", not "as_test_one". Who can tell me how to write this sql query? Thanks a lot.

Thanks

Winnie

I found that Excel does not allow C-lang style escape sequence. E.g. "

like escape is not allowed. I tried with other tinkering as well but

did not work. Could not found direct pointer from Excel help.

Can somebody help, how to put escape sequences in Excel functions?

Thanks for your time.

- KA

function or something like that but I forgot how or where to do it. Does

anyone know how to do a game??? Game looks like flight simulator.

2. How to set Date&Time like access

Format(Now(), "yyyy-mm-dd hh:nn:ss")

Is this possible to be achieved by clicking one button and within ONE row can be two fields with value like NOW() and UUID in terms of MYSQL?

Need help.

i want to create pie chart in Excel 2003 usign c#.

Actually i have tow columns(A,B) in my excel. one is question and another is response("yes/No").

so i have a count of number of yes and number of no. so i need to drwa a pie chart which show show no of ues and no of no.no of yes should be in blue color and no of no should be red color. so please show me some sample code to draw pie chart in Excel using c#.

Can anyone tell me how to join two arrays in Excel (using formulas)? I want {1,2,3} and {4,5,6} to become {1,2,3,4,5,6}. I have tried using ":" and "&" and everything else I could think of.

I do not want to do either of the following:

- Create the array {"14", "25", "36"} or anything like that

- Do it by naming ranges, etc. (the ranges I wanna join are "dynamic")

- Use VBA to do it

Here is my latest attempt, which did not work, but may give you an idea what I am looking for:

=SMALL(INDIRECT(ADDRESS(2,MATCH($B$1,'Data'!$1:$1,0)) & ":" & ADDRESS(1000,MATCH($B$1,'Data'!$1:$1,0))) :INDIRECT(ADDRESS(2,MATCH($C$1,'Data'!$1:$1,0)) & ":" & ADDRESS(1000,MATCH($C$1,'Data'!$1:$1,0))),3)

automatically? I have it set up to calculate how many hours each person

worked subtracting out time for lunch. How do I get it to read that if the

hours in the regular hours column is over 8 a day, to put the difference in

the overtime field?

Thank you.

know how much of the time was in the last 90 days, I'm looking for a formula

that will help me sort, and add the data from just the last 90 days.

So I am a poker player and I am trying to do some calculations about EV(expected value). I am really just trying to calculate if a certain move has positive or negative EV.

I have one example for you.

So the formula is like this:

FOLD EQUITY Formula: EV = [EV(fold)] * x +[EV(call)] * (1-x)

EV(call)=-12.85

EV(fold)= 370

EV(total) = 370x-12.85(1-x)

EV(total) = 370x-12.85+12.85x

EV(total) = 382.85x-12.85

12.85 = 382.5x

x=12.85/382.85

X=3.4%

I can find out EV(call) and EV(fold) values thru other calculations and software. All i would like to do is to plugg in the numbers into a excel formula and get the result.

notes: Ev(total)= 0 just so it does not bring any confusion.

I would be Extremly glad if somebody could help me out with this.

I uploaded my excel file on rapidshare.

http://rapidshare.com/files/89909847/evcalc.xls.html

Cheers

Fish

If you want to determine the number of weeks between two dates, just use

=(B1-A1)/7

*******************

~Anne Troy

www.OfficeArticles.com

www.MyExpertsOnline.com

"Linda" <Linda@discussions.microsoft.com> wrote in message

news:18449258-05DB-4087-B9D1-219C5D699052@microsoft.com...

> I need to figure out how to calculate future dates in excel in # of weeks.

> Is there an easy way to do this?

first day i import ms sql server data using excel vba(ADO)

i change a data in excel.

second i want to import new records.

eg:

first 150 records i import in excel 2007.

second day new records add in sql server 25 records. Total 175 records.

How to imports new records in excel vba.

I have a table as per attached. I have to calculate manually many times in a day. Manual calculation is very tidious , annoying and take too much time to complete. I need automatic calculation.

Example : when I enter any Draft value which is not mentioned in table, such as 4.432 ,must be come out exact interpolated value for DISPMT,LCB,LCF,TKM,MTC,TPC etc. In the table draft difference between the two is 0.1 meter. But actual draft of the ship is not exactlly as table, actual draft value is always between the two drafts.

Kindly help me which function to be used and how to calculate to obtain interpolated exact value for any draft value which is not mentioned in the table.

Thank you very much for your kind attention and help.

Column B's values depend on the values of Column A -- once a user

selects a value in the list of column A, column B will populate a list

crresponding to the selected value in Column A. There are about 1000

rows in the sheet and for each row, a user has to first select from

Column A list and then Column B list. I have implemented this

funtionality using the method describing here:

http://www.ozgrid.com/News/excel-dependent-lists.htm

Now my boss wants me to do it using macro/VBA. Because the lists in

each cell that I created in the above way are not the control

"listbox", they just appear to be lists. So I don't know how to refer

to a list in a cell and how to program the event when a user selects an

item from the list.

The article mentioned above says this can be done using VBA, but it

doesn't say how. Any suggestions would be highly appreciated!

Anybody has any solution for this, please email to me asap. Thankx...

Note: I wish to delete the filtered rows by using macro.

No luck finding an answer? You could always try Google.