Substracting two datetime cells

E

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 = ?
 
F

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
 
Top