guy77015

Hello, I need your help with the following. I need a formula to calculate time card times in Excel 2007.

The time need to be rounded up or down to the nearest 15 minutes.

Like:

53 --> 00 <-- 7

8 --> 15 <-- 22

23 --> 30 <-- 36

37 --> 45 <-- 52.

In other words, if an employee worked 3:52 hours, it will be rounded down to 3:45 and the result will be posted into ADP as decimals like 3.75 hours.

The time cards come in the following formar:

2:00PM to 5:23PM

9:05AM to 3:06PM

6:18PM to 11:53PM

I need to calculate all these time one by one into decimals. For example 2:00PM to 5:23PM = 3.50

Please help.

If I buy a house in OC, do I have to pay property taxes right away? How much? Let's say if I purchase a house for $450,000 today, is the taxes included in the price or do I have to pay taxes the same day in a separate bill? What is the tax rate if any?

If you were to start a new small business today, who would be the first person you hire and why? Also, what position would you take? CEO, CFO, accountant, regular employees, advertiser, vice-president of operation, etc... I just would like to know who can help setup a business and build it from the ground up.

Where I work, most people work Monday-Friday. Some work Saturday and around 5 people work some Sundays. Some like me work every other Saturday but, not Sunday. In other words, the regular working days are Mon-Fri. My employer calculate one day salary as follow:

$60,000/365 = $164.38

My question is, is it ok under California or federal law to use 365 days to calculate 1 paid payday?

Please provide references.

Where can I find Panera Bread month by month revenues, wages paid, advertising expenses, etc for the year 2010, 2009, 2008? I've seen Edgard and Yahoo Finance but, they do not provide by month just yearly summary.

I send my taxes by mail on 2/1/11 and a day after 2/2/11 I want to submit my taxes online so, I can get a faster refund. My question is:

Can I e-file my taxes even when I sent it by mail and the IRS is about to receive the mail after the e-file?

Where can I find an Excel template that can calculate the exchange rate of two different currencies. For example yuan 400,000 at yuan 1 = $0.12 how much in USD.

Also yuan 200,000 = $30,000 what is its exchange rate?

I am looking for an Excel spreadsheet that can calculate the rate and the amount.

I am married but, broke up with my wife July 2009. The divorce will be completed on March 30, 2010. I want to file my 2009 taxes as single, can it be possible? Or am I obligated to file as married with separated returns?

We have NO kids together.

The event is celebrate in Christmas and there are vendors from different countries. They sell different types of foods from their original countries. The event also has some free shows and music. Is celebrate in Balboa Park. The event usually runs for a few days. There is one main scenarios with a big Christmas tree and the main chores and band sings there. I would like to know the name of the event and they days it will be available.

I have Linux VPS hosting

I installed Wordpress later version, and when I'm trying to upload photos into my Wordpress gallery I get the error below:

(Error : Exceed Memory limit. Require : 56.59 MByte)

What can I do?

I submitted a grade appeal to my university in California and after long wait they denied my appeal. I know I can win this because they teacher was very, very bad and did not know the subject, but the university denied my appeal anyway.

Where else can I take my appeal and complaint about the bad education of this university?

Biscuit Motors had earnings of $8 million last year. It made $5 million on investment in projects with positive net present values. Smith owns 20% of the firm’s common stock. Assume that Smith desires no change in proportional ownership of Biscuit Motors and the firm wishes to maintain a constant debt-equity ratio.

What will be Smith’s action in response to

a. Biscuit Motors’s paying out dividends of $5 million?

b. Biscuit Motors’s paying out dividends of $1 million?

c. Biscuit Motors’s paying out dividends of $3 million?

Assume that two securities constitute the market portfolio. Those securities have the following expected returns, standard deviations, and proportions:

Security A

Expected return 10%

Standard Deviation 20%

Proportion .4

Security B

Expected return 15%

Standard Deviation 28%

Proportion .6

Based on this information, and given a correlation of .30 between the two securities and a risk-free rate of 5%, specify the equation for the capital market line.

What is the variance of a portfolio whose weighting is equally divided between four assets with low correlations and standard deviations of 5%, 15%, 20% and 30%?

a. 17.50

b. 1.75

c. .70

d. .10

An investor has a portfolio with 60% in a riskfree asset with a return of 5% and the rest in a risky asset with an expected return of 12% and a standard deviation of 10%. Respectively, the expected return and standard deviation of the portfolio are

a. 7.8%, 6%.

b. 9.2%, 6%.

c. 7.8%, 4%.

d. 9.2%, 4%.

I have the following SUV and I need to know what exactly I have in order to buy parts.

Ford

Explorer

1997

5.0

V8

4x2

I need some additional information like because I do not know if my SUV is Explorer XTL or Sport or Limited Edition, etc, etc.

How can I find all those additional information?

I sell PHP/MySQL scripts and I'd like to know how can I protect my scripts against piracy and/or illegal resale and redistributions.

I'm a bad runner, but I need to improve my speed and distance. There's any medication or supplement that can help gain muscle on my leg and my body? Because I'm also want to be able to do more pullups. I need to get better physical condition. Legs and arms.