<What did I do wrong?>
Nothing. Just Format>Cells>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 Otten
| 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
| >
| >
| > | 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
| > | >
| > | > |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?
| > | > |
| > | >
| > | >
| > | >
| >
| >
| >
