Question about Microsoft Excel for PC

1 Answer

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

  • 2 more comments 
  • 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.

×

1 Answer

  • 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
  • 4,889 Answers

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

Posted on Feb 21, 2008

  • 1 more comment 
  • eagle338
    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
    eagle338 Feb 22, 2008

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

  • eagle338
    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

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

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

1 Answer

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

1 Answer

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

913b74c4-c453-4afa-be3a-c3e781816e8d.png

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)
bc7a3bcd-ec6e-4936-9887-c6372904fe9f.png

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.
1fbf065d-6c1d-440a-9069-783127aa9842.png

Mar 29, 2014 | Office Equipment & Supplies

1 Answer

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

2 Answers

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
pads for three seconds.
2. Press the More+ or Less - pad to select
12 or 24 hour.

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

10 Answers

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
received with your order.
The instructions are as follows:
Button Functions:
A. Light
B. Mode
C. Start
D. Reset
Standard Time Adjustment:
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
for speedy advance.
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...

1 Answer

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)))

Need more information on what the numbers are to help further

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

5 Answers

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

1 Answer

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

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

93 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18375 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...