Elapsed time

[Guest]

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

 

[David Biddulph]

I'm assuming that if you got 1:00 and if you're talking of 30 minutes, you
don't actually have 12:30 and 12:40?
Assuming that your difference is 30 minutes, you need to convert the time
from Excel's time unit of days into minutes, so multiply by 24 and by 60,
hence:
=(B2-B1)*24*60*2 [and format the result as General or Number, not as Time]

 

[T. Valko]

b1-12:30
b2-12:40

The difference is 10 minutes. So:

=(B2-B1)*1440*gpm

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

 

[Guest]

Ok the egg is on my face I tried that scheme and it didn't seem to work so I
must have done something wrong probably not enough coffee any it worked
great thank you for all of the help.
Cliff

I'm assuming that if you got 1:00 and if you're talking of 30 minutes, you
don't actually have 12:30 and 12:40?
Assuming that your difference is 30 minutes, you need to convert the time
from Excel's time unit of days into minutes, so multiply by 24 and by 60,
hence:
=(B2-B1)*24*60*2 [and format the result as General or Number, not as Time]
--
David Biddulph

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