View Single Post
  #1   Report Post  
numberman37
 
Posts: n/a
Default How can I use a time difference in a subsequent formula in Excel?

When subtracting two dates/times from each other, Excel stores the result as
a number different from the displayed result (e.g., displayed result = 2.42
hours but stored number = 0.1125.) How can I effectively use the displayed
result in a subsequent formula rather than the stored number?