Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Recording elapsed time | New Users to Excel | |||
time elapsed formula | Excel Worksheet Functions | |||
Need Elapsed Time Help | Excel Worksheet Functions | |||
elapsed time | Excel Worksheet Functions | |||
Elapsed time | Excel Discussion (Misc queries) |