Thread: Difference between two times
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
GARYWC GARYWC is offline
external usenet poster
  
Posts: 80
Default Difference between two times
The times are in E16 and G16 so I've changed Claus's formula to:

=TEXT(G16-E16,"h")&" hrs "&TEXT(G16-E16,"m")&" mins" formula.

When I paste that formula in C16, the result is 2 hrs 1 mins.

When I paste that formula into the other cells in column C, the result is 2 hrs 1 mins, regardless of the contents in columns E and G.
Reply With QuoteReply With Quote