we have a flowmeter that I need to monitor. I take date and time readings.
What formula do i use to calculate the flowrate (kiloliters/ minute)?

I have a cell inwhich i have calculated the time difference (eg 00:30) and
another cell where I calculate the quantity (eg: 6.725) now how do I get
excel to work out 6.725/ 00:30. the result is supposed to be 0.2047333 kL/min

I don't know where you got your answer from.
If 6.725 is kL, and it's divided by 30 minutes, you should get 0.224167

If 0.224167 is your actual correct answer, then you can try this formula in
C1, with C1 formatted as "General" or "Number", and with quantity in A1 and
actual time in B1:

=A1/(B1*1440)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"Maintenance R.Eng" <Maintenance wrote in
message ...
we have a flowmeter that I need to monitor. I take date and time readings.
What formula do i use to calculate the flowrate (kiloliters/ minute)?

I have a cell inwhich i have calculated the time difference (eg 00:30) and
another cell where I calculate the quantity (eg: 6.725) now how do I get
excel to work out 6.725/ 00:30. the result is supposed to be 0.2047333
kL/min

On Sun, 26 Jun 2005 03:53:01 -0700, "Maintenance R.Eng" <Maintenance
wrote:

we have a flowmeter that I need to monitor. I take date and time readings.
What formula do i use to calculate the flowrate (kiloliters/ minute)?

I have a cell inwhich i have calculated the time difference (eg 00:30) and
another cell where I calculate the quantity (eg: 6.725) now how do I get
excel to work out 6.725/ 00:30. the result is supposed to be 0.2047333 kL/min

Are you sure about the result?

If your 00:30 represents 30 minutes; and your 6.725 represents kiloliters; and
you want your result in kiloliters/minute; the general formula is:

Rate = time/quantity or 6.725/30 = 0.2241666667.

In Excel, since time is stored as fractions of a day, the formula would be:

=Quantity/(Time*1440)

The 1440 represents the number of minutes in a day.

But, I don't understand how you obtain the result you posted. So maybe I am
missing something.




--ron

Ok my bad work with a calculator - .224166 is the rate per minute. I managed
to get a flowrate by
=qty/time*24 (gives me my hourly rate which is what I finally needed)

Thank you very much