+ Reply to Thread
Results 1 to 2 of 2

How can I calculate flowrate?

  1. #1
    Maintenance R.Eng
    Guest

    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. #2
    Forum Contributor
    Join Date
    08-02-2005
    Posts
    102
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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