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

×

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

I am trying to figure out a payroll formula. I


Here is how you could do the formula with two one column having the hours of each day in it and the overtime being in another cell:

Example:

Column A Column B
8
8
8
2
8
8
0
Total 40 OverTime 2

Formula in this cell where 40 is at:
=IF(SUM(A1:A7)>40,40,SUM(A1:A7))

Formula in cell where 2 is at:
=IF(A8>40,0,SUM(A1:A7)-A8)

Let me know if this helps.

Jan 01, 2010 | Microsoft Excel 2007 Home and Student...

1 Answer

What is the formula to convert the time of 4:15 to 4.25 hours? I'm trying to add up the number of hours I do child care.


If you calculate 0.1hr as 6mins, you can get what you ask for.. This is just 1/10th of an hr.. to put it more easy, the time which you get, convert it into mins.. (1hr=60mins) and then divide by 60.. For eg:

3hrs = 180mins -> 180/60 = 3hrs
3hrs 20mins = 180+20mins -> 200/60 = 3.33hrs
4hrs 30mins = 240+30mins -> 270/60 = 45.hrs..

Simple math, isn't it??

Mar 20, 2009 | Microsoft Excel for PC

1 Answer

Working hours calculation (with Neg time) in Excel


Hi Aviks,
Normal average works well for linear distribution, but here is non-linear distribution of work. So here is the formula that has been taken from project management concepts. Please try for different values of x and y

Try to keep x+y=6

=(StandardWorkingHr*x+(ActualWorkingHr-StandardWorkingHr)*y)/(x+y)

e.g.
=(StandardWorkingHr*5+(ActualWorkingHr-StandardWorkingHr)*1)/5)
if you can share data with me, I can give you the exact formula.

Mar 09, 2009 | Microsoft Office Professional 2007 Full...

4 Answers

I want the excel compound interest formula


=10000*(1+0.96)^12
=10000*(1+0.10)^18
=10000*(1+0.10)^24

Dec 02, 2008 | Microsoft Office Professional 2007 Full...

3 Answers

Need excel solution


Hello ycool11, If your asking what i think you are the formula would be
=(a2-a1)*24
That assumes a2 is that last date entered and a1 is the initial starting date. if you would like a more intense formula let me know and i'm sure i can help.

Oct 22, 2008 | Microsoft Excel for PC

2 Answers

Excel formula


Hello,
The formula should go like this:
=IF(C11>40,(C11-40)*D11,0)
This one will give you the result of (ONLY overtime hours)*(hourly wage), and if there are no overtime hours the result is 0.
Now, if you need to multiply that result with say 1,5 or whatever - insert the number you need like this:
=IF(C11>40,(C11-40)*D11*1.5,0)

If you need more help, please ask.

Sep 14, 2008 | Business & Productivity Software

1 Answer

Excel calculations


Just enter using this style


TIME IN TIME OUT HOURS 10:00 16:50 6:50 10:22 17:34 7:12 9:00 10:00 1:00
the formula in HOURS is Time Out - Time In

Mar 20, 2008 | Business & Productivity Software

1 Answer

Microsoft Excel Formula


Hi, probably the easiest way would be to create a macro and attach it to a button which would automatically sort the required column in descending order. When Excel does this it reorders the whole list so that the names correspond correctly. To do this you simply go to the tools menu and select macros and "record new macro" then click any cell in the results that make that person coming first etc, then click the sort descending button on the toolbar, then click stop record.
Afterwards create a button from the "toolbox controls" and then view the code for both the button and the macro and copy the macro code and paste it into the "click" option for the button.
If you need an example or anything else give me a yell.
Regards
SeaJade

Mar 05, 2008 | Microsoft Excel for PC

1 Answer

Spreadsheets


You need to calculate the totals for each category, by entering a formula such as: = C2 * 12.00 where C2 is the location of the hours and your hourly rate is $12.00. You can fill in the C2 part in each formula by clicking on the cell you want the total in, then typing the equal sign, then selecting the cell that you want to get the hours from, then enter the multiply operator (asterisk *) which is a Shift + 8 on your keyboard or the * over the 9 key on the numerical keypad. Repeat for each entry, using the correct cell and the correct amount (in this example it might be $18.00 for overtime hours). Then you just total all the formulas by using Autosum, which you invoke by using the Ʃ symbol, which will give you a sum of the cells you select. If this isn't clear enough, please let us know.

Hope this will FixYa!!!

Mar 03, 2008 | Business & Productivity Software

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

Related Topics:

91 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...