Question about Microsoft Excel for PC

# Trying to figure the formula below based on 9 hour work weeks and 24 hr weekends

The formula is off by 11 minutes?

=(DATEDIF(A12,B12,"d")*9)+((B12-INT(B12))*24-(A12-INT(A12))*24)

Posted by on

• globalc1 Feb 21, 2008

Yes please. I know the basic formula is correct. I just need to find that extra 11 minutes.

• globalc1 Feb 21, 2008

I would appreciate that.

• globalc1 Feb 21, 2008

I need to exclude weekends and holidays from this formula. How can we accomplish this?

• globalc1 Feb 22, 2008

It should be for the year. and the month please. In other words I need one for the month and one for the year. Thank you.

×

• Level 3:

An expert who has achieved level 3 by getting 1000 points

Superstar:

An expert that gotÂ 20 achievements.

All-Star:

An expert that gotÂ 10 achievements.

MVP:

An expert that gotÂ 5 achievements.

• Master

Please be more clear with the question.. Do you want me to analyze the formula?

Posted on Feb 21, 2008

• 1 more comment
• eagle338 Feb 21, 2008

strange i have checked it myself... its perfect! Don't know where its going wrong..But i will talk to other experts and let you know..

• eagle338 Feb 22, 2008

Do you want the formula to be for a month or year?

• eagle338 Feb 24, 2008

Can you plase get me the spread sheet you have used for this? You can upload it on rapidshare and provide me the link.. The problem is that i have some missing info like what is "d" and also the format of spreadsheet you are going to use this on

×

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### If i work 16 hours a week how much money do i get for a 14 year oldd

Multiply hourly wage by number of hours in pay period.
The answer is your gross pay. If this is un-taxed income, you earn that much. If it is taxed, then multiply by about 0.70 to determine take home pay after taxes, although taxes vary by location.

Ex: If I work 16 hours at \$9.50/hr, I make \$152/week before taxes, but only take home \$106.40 (\$152 x 0.70) per week after the government takes its cut.

Use a calculator, hand-held or on the computer in accessories, cell phone app, or pencil and paper with simple multiplication formula Wage x Hours Worked Per Pay Period x (1.00 - Tax Rate) = Take Home Pay Per Pay Period.

Mar 17, 2015 | Refrigerators

### What are your office hours 9-5 ?

Contact Customer Support Fixya
Our support team is happy to answer any questions regarding Fixya's website. Simply fill out and submit the form below and we will be in touch.

Dec 16, 2014 | Toys

### Volume of triangular pyramid

Here is to get you started. To increase the size of the image do a CTRL Plus (+) in your browser.
You need to calculate the slant height of the pyramid for the formula of the lateral area. You should find a value of (1/2)*SQRT(203) or about 7.1239 cm

You need to calculate the altitude (height) of the pyramid from the apex (summit) to the center of the base triangle (center of inscribed circle, barycenter, orthocenter). The hypotenuse of such triangle is the slant height. One leg is the altitude (to be found), the measure of the second leg is (1/3) the altitude of the equilateral triangle that forms the base. You should find (1/3) m MH= (1/3)* (11/2)*SQRT(3)

1. Calculate the area of the base (use a formula for the equilateral triangle or the general formula for a triangle: you have its height MH ).
2. Lateral area = 3 times the area of triangle Triangle ECD (in yellow above).
3. Total area = area of base + lateral area.
4. Volume= (1/3)(Area of base)* (height of pyramid)
If you can see the details on the screen capture below, fine, Press CTRL + in your browser to increase the size.

Mar 29, 2014 | Office Equipment & Supplies

### I have a bell f20 bicycle program...i have been trying to set the time...can someone tell me how to set the time without erasing everything on the program...

Click on the right side of the red button until you reach the clock (after SCAN). Hold down the left side of the red button until you see "12 HR" click--choose "12 HR" or "24 HR" (24 HR is military time). Click on the right side of the button to select the hour and change with the left side to change the hour. Click the right side of the button to change the minutes. Finally, click the left side of the button to move away from the clock. Other settings are intact.

Nov 15, 2010 | Cycling

### The digital clock seems to be set to 24 hr insted of 12 hr time

No Problem here ya go

To change the clock to 24-hour format:
1. Press and hold the CANCEL and Delay
2. Press the More+ or Less - pad to select
12 or 24 hour.

Jan 14, 2009 | Maytag MER5552BAW / MER5552BAQ /...

### How do I adjust date of my watch bought from GAP

Here is the manual from GAP customer service.

Dear gap.com Customer,
Thank you for your email regarding the Sporty Printed Watch user
instructions. Please accept our apologies that no directions were
The instructions are as follows:
Button Functions:
A. Light
B. Mode
C. Start
D. Reset
1. To set the time, press the Mode button three times (The seconds and
the word Tuesday should start flashing).
2. If the seconds position shows less than 30 seconds, pressing the
Start button will reset the seconds to 00. If the seconds position shows
more than 30 seconds, pressing the Start button will reset the seconds
to 00 and the minutes will increase by 1.
3. Press the Reset button until the area you want to change starts
flashing (i.e., second, minute, hour, day, month, and weekend. Press
Start button once for per unit increment, press and hold for 3 seconds
4. At completion, press Mode button to resume standard time display.
To reset the Alarm:
Press the B: Mode button until you reach the alarm.
Press the D: Restart button.
Press the C: Restart button to get back to the time

Sep 29, 2008 | Tag Heuer 2000 Aquaracer WAB2011.BA0803...

### If formula

What are the "cases"? Your example "more then 8 or less then 9 use 400" implies that there is a decimal part e.g. 8.5 . Is that right?

You dont need to test in both directions
e.g. assuming you name the cell with your number in it "cases"
=if(cases<9,400,if(cases<10,410,if(cases<11,420,430)))

Aug 07, 2008 | Microsoft Excel 2000 Step by Step...

### Acqua Indiglo water resistant watch with alarm 30m

Press and hold the MODE button (bottom left) for approximately 3 seconds.

When the Alarm set time starts flashing, press the MODE button once more. Now the seconds for the watch time should be flashing.

Use the START/STOP button (top right) to move bewteen items and the SPL/RESET button (bottom right) to change the item.

Moving between all items, it will take you through: seconds, minutes, hours, month, date, day of the week. Simply press MODE when your settings are complete.

Jul 25, 2008 | Watches

### Canon P23 DHV Calculator / I need some info on it

What I do is just base the time on quarter hour and the 24 hour clock.

Example

6:30am = 6.5

3:45pm = 15.75

every 15 min = .25

Clock in at 11:45 am and clock out at 5:15 pm
17.25-11.75=5.5

Jan 29, 2007 | Canon P23-DHV Calculator

## Open Questions:

#### Related Topics:

93 people viewed this question

Level 3 Expert

Level 3 Expert