Thread: Subtracting Time
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Subtracting Time
=B2-A2 and format as [h]:mm:ss
--
David Biddulph

Mark wrote:
I have for example 8:15:29 AM in one cell and 9:33:15 AM in another
cell and I need the amount of time between the the two


Reply With QuoteReply With Quote