difference between rows.

  1. G

    Formula(?) for working out difference of accruing hours against set hours per fortnight shown in 1 cell

    Hi, Can anyone help with the following? I have a spreadsheet with yearly hours budget/actual for my dept. of 24000 hours, which is divided into 26 fortnights giving 923hrs/fortnight. In 1 row I have the budget filled in for the year(26 cells of 923 hours). In the row below this, I have the...
    • Gelaw
    • Thread
    • difference between rows. formula formula calculation
    • Replies: 7
    • Forum: Excel Questions
  2. FuzzyTom

    Subtracting One Total From Another on a Different Row in a Query

    Hi, With help from MrExcel I have the following: SELECT qryTestUnion.EmployeeName, qryTestUnion.Day, Sum(qryTestUnion.Total) AS SumOfTotal, qryTestUnion.Source FROM qryTestUnion GROUP BY qryTestUnion.EmployeeName, qryTestUnion.Day, qryTestUnion.Source; the result is <TABLE border=1...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top