# How can I calculate flowrate?

1. ## How can I calculate flowrate?

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

2. The first thing you need to do is convert your time segments into decimals. To do this you need to multiply the time eg 00:30 by 1440 (this is because Excel handles time as fractions of 1 day (=24 hrs) so 30 minutes is actually 0.0208nnn. This then gets you 30 minutes as 30.00 rather than 00:30 so you can do something with it such as 6.725/30 which by my reckoning is 0.2242

Cheers
Jon

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1