Counting dates & time.

[GEM]

I have date and time in a cell like this, "February 11, 2009 - 13:15", I
formatted the cell like this, "mmmm dd, yyyy - hh:mm"

Now I want to count the exact days and time between to cells.

For example

A1=February 11, 2009 - 13:15
A2=February 14, 2009 - 16:24
A3=A2-A1

How can I get this to work??

 

[CurlyDave]

I have date and time in a cell like this, "February 11, 2009 - 13:15", I
formatted the cell like this, "mmmm dd, yyyy - hh:mm"

Now I want to count the exact days and time between to cells.

For example

A1=February 11, 2009 - 13:15
A2=February 14, 2009 - 16:24
A3=A2-A1

How can I get this to work??

Try,

=INT(A2-A1)&" days "&TEXT(A2-A1,"hh:mm")

 

[GEM]

Excellent!!! Thank you very much!!!

Try,

=INT(A2-A1)&" days "&TEXT(A2-A1,"hh:mm")