excel - Calculating a work week based on weekly time-sheet -


i trying calculate work week hours want match company's paycheck earned amount. far have this: 

 7/12/2011   7.90 7/13/2011   8.03 7/14/2011   7.83 7/15/2011   7.97 7/18/2011   8.20 7/19/2011   8.12 7/20/2011   8.15 7/21/2011   6.07 7/22/2011   8.12 7/25/2011   8.13 7/26/2011   8.1 7/27/2011   8.4 7/29/2011   8.27 8/1/2011    8.33 8/2/2011    8.18 8/3/2011    8.22 8/4/2011    6.72 8/5/2011    7.57 8/8/2011    8.07 8/9/2011    8.28 8/10/2011   5.8 8/11/2011   8.8 8/15/2011   8.2 8/16/2011   7.95 8/17/2011   8.17 8/18/2011   8.1 8/19/2011   7.8 8/22/2011   8.18 8/23/2011   9.7 8/24/2011   8.17 8/25/2011   8.18

and want match total this: 

check date earnings start  earnings end    earn type   earn amount 8/10/2011   7/26/2011   8/10/2011   salary          899.6 8/25/2011   8/11/2011   8/25/2011   salary          888.28

the company's pay period varies, that's why these days don't follow. far using =sumifs functions not giving result need. let me know if there's clarifications needs!

you should able use =sumifs() hours during pay period.

=sumifs(b:b,a:a,">="&f4,a:a,"<="&g4)

here,

  • column contains dates,
  • column b contains hours,
  • cell f4 earnings start date,
  • cell g4 earnings end date.

Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more