Elapsed time
 

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

Elapsed time
 

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

"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

Elapsed time
 

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

Elapsed time
 

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

"David Biddulph" wrote:

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

"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