Thread: How do I make a change in time into a number I can use to calcula.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sportystan Sportystan is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote