Thread: time formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vdmbqb vdmbqb is offline
external usenet poster
 
Posts: 36
Default time formulas

I have times generated in h:mm in cell A1 and A2 I need a formula in A3 that
subtracts A2 from A1 and produces the difference (either negative or
positive) in h:mm.
For instance, the time in A1 is 6:15 and the time in A2 is 6:00 I need A3
to return -:15 or -0:15. All I can get is ###########.

Thank you in advance for any help offered.

--
bob