advertisement
Forums

The Forum is sponsored by 
 

AAPL stock: Click Here

You are currently viewing the Tips and Deals forum
Spreadsheet: How to Divide Hours (4:30) by Volume
Posted by: Microman
Date: November 24, 2007 07:22PM
I am trying to do this spreadsheet. There is a volume being measured every so often during the day. I need to determine if the RATE is increasing, decreasing or staying the same.

I have created the spreadsheet with Date, Time, Duration, Amount and ml/hr columns.

The trouble I am having is calculating the ml/hr column.

I have the column that is duration since the last measurement. I want to take the volume during that time, and divide it by the time. I can't seem to make it work.

Maybe because the Duration column is in the format 6:57 which is actually a time and not 6 hrs and 57 minutes.

What can I do?



Edited 2 time(s). Last edit at 11/24/2007 07:30PM by Microman.
Options:  Reply • Quote
Re: Spreadsheet: How to Divide Hours (4:30) by Volume
Posted by: space-time
Date: November 24, 2007 08:42PM
convert the time to seconds, do the math in seconds, it's easier and logical.
Options:  Reply • Quote
Re: Spreadsheet: How to Divide Hours (4:30) by Volume
Posted by: Microman
Date: November 24, 2007 09:32PM
Thanks, did a search a found a way to do that:
[mathforum.org]
Options:  Reply • Quote
Sorry, only registered users may post in this forum.

Click here to login

Online Users

Guests: 294
Record Number of Users: 186 on February 20, 2020
Record Number of Guests: 5122 on October 03, 2020