I have searched the posts for the answer to my problem and have not found it
so here I go:
I have a column of time such as b1-12:30, b2-12:40 and so on what I need to
do is arrive at the elapsed time from b2 & b1 (no problem there) the next
step is multiply the result by a number of gallons per minute such as 2gpm
sounds simple enough right? here is my formula =(B2-B1)*2 the result returns
1:00 what I need it to return would be 60 which would reflect 30 mins time 2
gallons per minute or 60 gallons
Thanks for the help
Cliff