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?=(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
quot;Shearriesquot; gt; 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?
|
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,D5quot;Niek Ottenquot; wrote:
gt; =(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)
gt;
gt; Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets should be,
gt; etc. Even better: tell us what problem you're trying to solve
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Shearriesquot; gt; wrote in message ...
gt; |I need to formulate this,
gt; | the sum of multiple cells minus the sum of different mutiple cells divided
gt; | by the difference between to times.
gt; | Does anyone know how to do this?
gt; |
gt;
gt;
gt;
=(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 Ottenquot;Shearriesquot; gt; 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
|
|
| quot;Niek Ottenquot; wrote:
|
| gt; =(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)
| gt;
| gt; Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets should
be,
| gt; etc. Even better: tell us what problem you're trying to solve
| gt;
| gt; --
| gt; Kind regards,
| gt;
| gt; Niek Otten
| gt;
| gt; quot;Shearriesquot; gt; wrote in message ...
| gt; |I need to formulate this,
| gt; | the sum of multiple cells minus the sum of different mutiple cells divided
| gt; | by the difference between to times.
| gt; | Does anyone know how to do this?
| gt; |
| gt;
| gt;
| gt;
THANKS, I'll try that.
quot;Niek Ottenquot; wrote:
gt; =(SUM(E5:G5)-SUM(E4:G4))/(D6-D5)
gt;
gt; 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..........
gt; If you want that to be hours, multiply by 24:
gt;
gt; =(SUM(E5:G5)-SUM(E4:G4))/((D6-D5)*24)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt;
gt; quot;Shearriesquot; gt; wrote in message ...
gt; | I'm sorry, I'm new to this. I need a cell to give me a per hour answer
gt; | for example
gt; | sum of E4,F4,G4 subtracted from the sum of E5,F5,G5 and the divided dy the
gt; | difference between time in D6,D5
gt; |
gt; |
gt; | quot;Niek Ottenquot; wrote:
gt; |
gt; | gt; =(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)
gt; | gt;
gt; | gt; Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets should
gt; be,
gt; | gt; etc. Even better: tell us what problem you're trying to solve
gt; | gt;
gt; | gt; --
gt; | gt; Kind regards,
gt; | gt;
gt; | gt; Niek Otten
gt; | gt;
gt; | gt; quot;Shearriesquot; gt; wrote in message ...
gt; | gt; |I need to formulate this,
gt; | gt; | the sum of multiple cells minus the sum of different mutiple cells divided
gt; | gt; | by the difference between to times.
gt; | gt; | Does anyone know how to do this?
gt; | gt; |
gt; | gt;
gt; | gt;
gt; | gt;
gt;
gt;
gt;
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
quot;Niek Ottenquot; wrote:
gt; =(SUM(E5:G5)-SUM(E4:G4))/(D6-D5)
gt;
gt; 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..........
gt; If you want that to be hours, multiply by 24:
gt;
gt; =(SUM(E5:G5)-SUM(E4:G4))/((D6-D5)*24)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt;
gt; quot;Shearriesquot; gt; wrote in message ...
gt; | I'm sorry, I'm new to this. I need a cell to give me a per hour answer
gt; | for example
gt; | sum of E4,F4,G4 subtracted from the sum of E5,F5,G5 and the divided dy the
gt; | difference between time in D6,D5
gt; |
gt; |
gt; | quot;Niek Ottenquot; wrote:
gt; |
gt; | gt; =(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)
gt; | gt;
gt; | gt; Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets should
gt; be,
gt; | gt; etc. Even better: tell us what problem you're trying to solve
gt; | gt;
gt; | gt; --
gt; | gt; Kind regards,
gt; | gt;
gt; | gt; Niek Otten
gt; | gt;
gt; | gt; quot;Shearriesquot; gt; wrote in message ...
gt; | gt; |I need to formulate this,
gt; | gt; | the sum of multiple cells minus the sum of different mutiple cells divided
gt; | gt; | by the difference between to times.
gt; | gt; | Does anyone know how to do this?
gt; | gt; |
gt; | gt;
gt; | gt;
gt; | gt;
gt;
gt;
gt;
lt;What did I do wrong?gt;
Nothing. Just Formatgt;Cellsgt;Number 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 Ottenquot;Shearriesquot; gt; 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
|
| quot;Niek Ottenquot; wrote:
|
| gt; =(SUM(E5:G5)-SUM(E4:G4))/(D6-D5)
| gt;
| gt; 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..........
| gt; If you want that to be hours, multiply by 24:
| gt;
| gt; =(SUM(E5:G5)-SUM(E4:G4))/((D6-D5)*24)
| gt;
| gt; --
| gt; Kind regards,
| gt;
| gt; Niek Otten
| gt;
| gt;
| gt; quot;Shearriesquot; gt; wrote in message ...
| gt; | I'm sorry, I'm new to this. I need a cell to give me a per hour answer
| gt; | for example
| gt; | sum of E4,F4,G4 subtracted from the sum of E5,F5,G5 and the divided dy the
| gt; | difference between time in D6,D5
| gt; |
| gt; |
| gt; | quot;Niek Ottenquot; wrote:
| gt; |
| gt; | gt; =(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)
| gt; | gt;
| gt; | gt; Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets
should
| gt; be,
| gt; | gt; etc. Even better: tell us what problem you're trying to solve
| gt; | gt;
| gt; | gt; --
| gt; | gt; Kind regards,
| gt; | gt;
| gt; | gt; Niek Otten
| gt; | gt;
| gt; | gt; quot;Shearriesquot; gt; wrote in message
...
| gt; | gt; |I need to formulate this,
| gt; | gt; | the sum of multiple cells minus the sum of different mutiple cells divided
| gt; | gt; | by the difference between to times.
| gt; | gt; | Does anyone know how to do this?
| gt; | gt; |
| gt; | gt;
| gt; | gt;
| gt; | gt;
| gt;
| gt;
| gt;
Thanks, my problem is solved
quot;Niek Ottenquot; wrote:
gt; lt;What did I do wrong?gt;
gt;
gt; Nothing. Just Formatgt;Cellsgt;Number or General
gt; Excel tries to be clever and as soon as time is involved in a calculation, it formats the result as time.
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt;
gt; quot;Shearriesquot; gt; wrote in message ...
gt; | Hi, me again. I gave me an answer in time and need a rounded whole number.
gt; | What did I do wrong?
gt; |
gt; | Sorry to keep bugging
gt; |
gt; | quot;Niek Ottenquot; wrote:
gt; |
gt; | gt; =(SUM(E5:G5)-SUM(E4:G4))/(D6-D5)
gt; | gt;
gt; | gt; 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
gt; 083333333..........
gt; | gt; If you want that to be hours, multiply by 24:
gt; | gt;
gt; | gt; =(SUM(E5:G5)-SUM(E4:G4))/((D6-D5)*24)
gt; | gt;
gt; | gt; --
gt; | gt; Kind regards,
gt; | gt;
gt; | gt; Niek Otten
gt; | gt;
gt; | gt;
gt; | gt; quot;Shearriesquot; gt; wrote in message ...
gt; | gt; | I'm sorry, I'm new to this. I need a cell to give me a per hour answer
gt; | gt; | for example
gt; | gt; | sum of E4,F4,G4 subtracted from the sum of E5,F5,G5 and the divided dy the
gt; | gt; | difference between time in D6,D5
gt; | gt; |
gt; | gt; |
gt; | gt; | quot;Niek Ottenquot; wrote:
gt; | gt; |
gt; | gt; | gt; =(SUM(A1:A10)-SUM(B1:B10))/(C2-C1)
gt; | gt; | gt;
gt; | gt; | gt; Just an example. But your question is not very precise. Maybe you can give some info on what cells, where the brackets
gt; should
gt; | gt; be,
gt; | gt; | gt; etc. Even better: tell us what problem you're trying to solve
gt; | gt; | gt;
gt; | gt; | gt; --
gt; | gt; | gt; Kind regards,
gt; | gt; | gt;
gt; | gt; | gt; Niek Otten
gt; | gt; | gt;
gt; | gt; | gt; quot;Shearriesquot; gt; wrote in message
gt; ...
gt; | gt; | gt; |I need to formulate this,
gt; | gt; | gt; | the sum of multiple cells minus the sum of different mutiple cells divided
gt; | gt; | gt; | by the difference between to times.
gt; | gt; | gt; | Does anyone know how to do this?
gt; | gt; | gt; |
gt; | gt; | gt;
gt; | gt; | gt;
gt; | gt; | gt;
gt; | gt;
gt; | gt;
gt; | gt;
gt;
gt;
gt;
留言列表
