Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? | |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? | |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? | | | | | |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? | | | | | |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? | | | | | |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? | | | | | | | | | | | | |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? | | | | | | | | | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not recognizing new data | Excel Discussion (Misc queries) | |||
Countif formulas change after doing a sort | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |