Thread: How to subtract times i.e. 18:55 day1 from 03:03 day2
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ken Johnson
 
Posts: n/a
Default How to subtract times i.e. 18:55 day1 from 03:03 day2
Hi Jaclyn,
If 18:55 day1 is in A1,
3:03 day2 is in B1, then =LEFT(B1,FIND(" ",B1)-1)-LEFT(A1,FIND("
",A1)-1) +1 in C1 yields 8:08 provided C1 has custom formatting [h]:mm.
Ken Johnson

Reply With QuoteReply With Quote