How do I make a change in time into a number I can use to calcula.
 

I am subtracting two times to get the difference, which I want to use in a
flow rate calculation, however, once I get the changes in time, I get an
error in the cell used for calculations. It seems the time factor in the
equation is throwing everything off. What I want to to is somehow use the
change in time (5:00 am from 6:00 pm which should equal 13 and not 13:00) so
it can be used in a formula

How do I make a change in time into a number I can use to calcula.
 

=(endtime-StartTime)*24

or in the formula, multiply the cell by 24

--
Regards,
Tom Ogilvy

"Sportystan" wrote in message
...
I am subtracting two times to get the difference, which I want to use in a
flow rate calculation, however, once I get the changes in time, I get an
error in the cell used for calculations. It seems the time factor in the
equation is throwing everything off. What I want to to is somehow use the
change in time (5:00 am from 6:00 pm which should equal 13 and not 13:00)
so
it can be used in a formula