Substracting two datetime cells

[Edgar Salcedo]

Hello, i'd like to know how can i substract two datetime
cells and obtain the result into another one?
i don't know if i can use the whole cell or just part of
it like the time and how.

17/08/2004 15:30 - 17/08/2004 11:12 = ?

 

[Frank Kabel]

Hi
and what should be your result?
You can try:
=A2-A1
and format the resulting cell with the custom format
D hh:mm