Thread: How to I subtract two dates & times to obtain a time
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default How to I subtract two dates & times to obtain a time
Hi,
use

=+RIGHT(B3,5)-RIGHT(A3,5)

and then format column c as

h:mm

hope this helps

"msbutton27" wrote:


Thanks but the [t]:mm would produce and error when trying to implement.


Reply With QuoteReply With Quote