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