|
|
|
|
New Member
|
|
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
|
|
|
Computer Expert and Renaissance Man
|
|
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)
|
|
|
New Member
|
|
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!
|
|
|
Computer Expert and Renaissance Man
|
|
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.
|
|
|
New Member
|
|
Mar 9, 2009, 07:48 AM
|
|
What would be the formula for the cell H30?
|
|
|
Computer Expert and Renaissance Man
|
|
Mar 9, 2009, 10:42 AM
|
|
Sum the column and add the standby.
|
|
|
New Member
|
|
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.
|
|
|
Computer Expert and Renaissance Man
|
|
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.
|
|
|
New Member
|
|
Mar 9, 2009, 11:24 AM
|
|
Perfect Scott.
Thank-you very very much for your prompt help.
Dave
|
|
|
Software Expert
|
|
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)
|
|
Question Tools |
Search this Question |
|
|
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
|