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?
| | |
| |
| |
| |
|
|
|
|