Thread: Difference between two times
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
GARYWC GARYWC is offline
external usenet poster
  
Posts: 80
Default Difference between two times
Your =TEXT(H16-F16,"h")&" hrs "&TEXT(H16-F16,"m")&" mins" formula results in 2 hrs 1 mins, regardless of the values in H16 and F16.
Reply With QuoteReply With Quote