b1-12:30
b2-12:40

The difference is 10 minutes. So:

=(B2-B1)*1440*gpm

=(B2-B1)*1440*2 = 20

--
Biff
Microsoft Excel MVP


"LtFass" wrote in message
...
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