Thread: Subtract times?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell[_2_] Terry Pinnell[_2_] is offline
external usenet poster
 
Posts: 50
Default Subtract times?

I'm so rusty at this! Could someone remind me how I get the difference
between two columns of Times please? I'm using familiar hours and minutes.

Col A Col B Col C
12:04 12:34 00:30 <--- How do I get this '00:30'?
16:35 18:34 01:59 etc

What cell format do I apply after typing in the data as say HH:MM? And
what function do I use for the result in Column C please?

--
Terry, East Grinstead, UK