Ask Experts Questions for FREE Help !
Ask
    DBJC's Avatar
    DBJC Posts: 5, Reputation: 1
    New Member
     
    #1

    Mar 9, 2009, 07:13 AM
    Excel Formulas
    Hello,

    I am looking for the proper formulas for a timesheet file. I have placed notes on the attachment explaing what I am looking for.
    Good luck and thanks !

    Dave
    Attached Files
  1. File Type: xls Blank Time Sheet.xls (92.0 KB, 218 views)
  2. ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #2

    Mar 9, 2009, 07:21 AM

    Is Row 30 a total of all time per day, including Standby?

    If so, you can use something like this:

    =IF(SUM(J7:J26)<8,0,(SUM(J7:J26)-8)*1.5)
    DBJC's Avatar
    DBJC Posts: 5, Reputation: 1
    New Member
     
    #3

    Mar 9, 2009, 07:34 AM

    Hey Scott,

    Half way there.
    Row 30 is the total of all regular time, including standby. You rock!

    Thanks!
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #4

    Mar 9, 2009, 07:38 AM

    Then the formula should work. It totals the hours excluding standby. If there are more than 8, it will calculate 1.5 of the hours over 8.
    DBJC's Avatar
    DBJC Posts: 5, Reputation: 1
    New Member
     
    #5

    Mar 9, 2009, 07:48 AM

    What would be the formula for the cell H30?
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #6

    Mar 9, 2009, 10:42 AM

    Sum the column and add the standby.
    DBJC's Avatar
    DBJC Posts: 5, Reputation: 1
    New Member
     
    #7

    Mar 9, 2009, 10:53 AM

    Sorry Scott, but I don't want that formula to total up more than 8 between cells H7-H26 and then add on cell H28. I hope that makes sense. If I just sum them up I will get overtime hours included.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #8

    Mar 9, 2009, 10:57 AM

    Ok, no more than 8 including the standby or no more than 8 plus the standby?

    If the former, than use:

    =IF(Sum(H7:27)+H29>8,8,Sum(H7:27)+H29)

    If the latter drop the standby row.
    DBJC's Avatar
    DBJC Posts: 5, Reputation: 1
    New Member
     
    #9

    Mar 9, 2009, 11:24 AM

    Perfect Scott.
    Thank-you very very much for your prompt help.

    Dave
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #10

    Mar 9, 2009, 04:22 PM

    As an alternate to having to SUM the range twice, this would do it one pass:

    =MIN(8,Sum(H7:27)+H29)

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Displaying formulas in Excel Spreadsheet [ 1 Answers ]

Formula currently appears in the cell rather than formula result value. I want the result value to appear in the cell and the formula to appear only in the formula bar. How do I make this change? I am working in Excel 2003.

Formulas in Excel 07? [ 5 Answers ]

Hello, how do I view formulas in all of the cells for excel 2007? Thanks.

Excel formulas [ 5 Answers ]

Hello I want to do something like the formulas SUMIF but with a text. For example two cell must be equal A b c Parts number Description qty 12545 bearing XKL 10 units

Calc. Empirical formulas and molecular formulas [ 1 Answers ]

:eek! : a sample is made of 18g of C and 81.5g of H... the molecular mass of the compound is 104g/mole calc. the empirical formula... calc. the molecular formula OK.. so I got the moles, I think.:confused: . C= 18g X 1mole = 1.4987g 1 ...


View more questions Search