Muliple formulas
 

I need to formulate this,
the sum of multiple cells minus the sum of different mutiple cells divided
by the difference between to times.
Does anyone know how to do this?

Muliple formulas
 

=(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)

Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets should be,
etc. Even better: tell us what problem you're trying to solve

--
Kind regards,

Niek Otten

"Shearries" wrote in message ...
|I need to formulate this,
| the sum of multiple cells minus the sum of different mutiple cells divided
| by the difference between to times.
| Does anyone know how to do this?
|

Muliple formulas
 

I'm sorry, I'm new to this. I need a cell to give me a per hour answer
for example
sum of E4,F4,G4 subtracted from the sum of E5,F5,G5 and the divided dy the
difference between time in D6,D5


"Niek Otten" wrote:

=(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)

Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets should be,
etc. Even better: tell us what problem you're trying to solve

--
Kind regards,

Niek Otten

"Shearries" wrote in message ...
|I need to formulate this,
| the sum of multiple cells minus the sum of different mutiple cells divided
| by the difference between to times.
| Does anyone know how to do this?
|

Muliple formulas
 

=(SUM(E5:G5)-SUM(E4:G4))/(D6-D5)

Be aware that times are stored as fractions of a day. So if D6 is 11:00 and D5 is 9:00, D6-D5 is not 2, but 083333333..........
If you want that to be hours, multiply by 24:

=(SUM(E5:G5)-SUM(E4:G4))/((D6-D5)*24)

--
Kind regards,

Niek Otten


"Shearries" wrote in message ...
| I'm sorry, I'm new to this. I need a cell to give me a per hour answer
| for example
| sum of E4,F4,G4 subtracted from the sum of E5,F5,G5 and the divided dy the
| difference between time in D6,D5
|
|
| "Niek Otten" wrote:
|
| =(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)
|
| Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets should
be,
| etc. Even better: tell us what problem you're trying to solve
|
| --
| Kind regards,
|
| Niek Otten
|
| "Shearries" wrote in message ...
| |I need to formulate this,
| | the sum of multiple cells minus the sum of different mutiple cells divided
| | by the difference between to times.
| | Does anyone know how to do this?
| |
|
|
|

Muliple formulas
 

THANKS, I'll try that.

"Niek Otten" wrote:

=(SUM(E5:G5)-SUM(E4:G4))/(D6-D5)

Be aware that times are stored as fractions of a day. So if D6 is 11:00 and D5 is 9:00, D6-D5 is not 2, but 083333333..........
If you want that to be hours, multiply by 24:

=(SUM(E5:G5)-SUM(E4:G4))/((D6-D5)*24)

--
Kind regards,

Niek Otten


"Shearries" wrote in message ...
| I'm sorry, I'm new to this. I need a cell to give me a per hour answer
| for example
| sum of E4,F4,G4 subtracted from the sum of E5,F5,G5 and the divided dy the
| difference between time in D6,D5
|
|
| "Niek Otten" wrote:
|
| =(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)
|
| Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets should
be,
| etc. Even better: tell us what problem you're trying to solve
|
| --
| Kind regards,
|
| Niek Otten
|
| "Shearries" wrote in message ...
| |I need to formulate this,
| | the sum of multiple cells minus the sum of different mutiple cells divided
| | by the difference between to times.
| | Does anyone know how to do this?
| |
|
|
|

Muliple formulas
 

Hi, me again. I gave me an answer in time and need a rounded whole number.
What did I do wrong?

Sorry to keep bugging

"Niek Otten" wrote:

=(SUM(E5:G5)-SUM(E4:G4))/(D6-D5)

Be aware that times are stored as fractions of a day. So if D6 is 11:00 and D5 is 9:00, D6-D5 is not 2, but 083333333..........
If you want that to be hours, multiply by 24:

=(SUM(E5:G5)-SUM(E4:G4))/((D6-D5)*24)

--
Kind regards,

Niek Otten


"Shearries" wrote in message ...
| I'm sorry, I'm new to this. I need a cell to give me a per hour answer
| for example
| sum of E4,F4,G4 subtracted from the sum of E5,F5,G5 and the divided dy the
| difference between time in D6,D5
|
|
| "Niek Otten" wrote:
|
| =(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)
|
| Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets should
be,
| etc. Even better: tell us what problem you're trying to solve
|
| --
| Kind regards,
|
| Niek Otten
|
| "Shearries" wrote in message ...
| |I need to formulate this,
| | the sum of multiple cells minus the sum of different mutiple cells divided
| | by the difference between to times.
| | Does anyone know how to do this?
| |
|
|
|

Muliple formulas
 

<What did I do wrong?

Nothing. Just FormatCellsNumber or General
Excel tries to be clever and as soon as time is involved in a calculation, it formats the result as time.

--
Kind regards,

Niek Otten


"Shearries" wrote in message ...
| Hi, me again. I gave me an answer in time and need a rounded whole number.
| What did I do wrong?
|
| Sorry to keep bugging
|
| "Niek Otten" wrote:
|
| =(SUM(E5:G5)-SUM(E4:G4))/(D6-D5)
|
| Be aware that times are stored as fractions of a day. So if D6 is 11:00 and D5 is 9:00, D6-D5 is not 2, but
083333333..........
| If you want that to be hours, multiply by 24:
|
| =(SUM(E5:G5)-SUM(E4:G4))/((D6-D5)*24)
|
| --
| Kind regards,
|
| Niek Otten
|
|
| "Shearries" wrote in message ...
| | I'm sorry, I'm new to this. I need a cell to give me a per hour answer
| | for example
| | sum of E4,F4,G4 subtracted from the sum of E5,F5,G5 and the divided dy the
| | difference between time in D6,D5
| |
| |
| | "Niek Otten" wrote:
| |
| | =(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)
| |
| | Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets
should
| be,
| | etc. Even better: tell us what problem you're trying to solve
| |
| | --
| | Kind regards,
| |
| | Niek Otten
| |
| | "Shearries" wrote in message
...
| | |I need to formulate this,
| | | the sum of multiple cells minus the sum of different mutiple cells divided
| | | by the difference between to times.
| | | Does anyone know how to do this?
| | |
| |
| |
| |
|
|
|

Muliple formulas
 

Thanks, my problem is solved

"Niek Otten" wrote:

<What did I do wrong?

Nothing. Just FormatCellsNumber or General
Excel tries to be clever and as soon as time is involved in a calculation, it formats the result as time.

--
Kind regards,

Niek Otten


"Shearries" wrote in message ...
| Hi, me again. I gave me an answer in time and need a rounded whole number.
| What did I do wrong?
|
| Sorry to keep bugging
|
| "Niek Otten" wrote:
|
| =(SUM(E5:G5)-SUM(E4:G4))/(D6-D5)
|
| Be aware that times are stored as fractions of a day. So if D6 is 11:00 and D5 is 9:00, D6-D5 is not 2, but
083333333..........
| If you want that to be hours, multiply by 24:
|
| =(SUM(E5:G5)-SUM(E4:G4))/((D6-D5)*24)
|
| --
| Kind regards,
|
| Niek Otten
|
|
| "Shearries" wrote in message ...
| | I'm sorry, I'm new to this. I need a cell to give me a per hour answer
| | for example
| | sum of E4,F4,G4 subtracted from the sum of E5,F5,G5 and the divided dy the
| | difference between time in D6,D5
| |
| |
| | "Niek Otten" wrote:
| |
| | =(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)
| |
| | Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets
should
| be,
| | etc. Even better: tell us what problem you're trying to solve
| |
| | --
| | Kind regards,
| |
| | Niek Otten
| |
| | "Shearries" wrote in message
...
| | |I need to formulate this,
| | | the sum of multiple cells minus the sum of different mutiple cells divided
| | | by the difference between to times.
| | | Does anyone know how to do this?
| | |
| |
| |
| |
|
|
|