Counting dates & time.

G

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??
 
C

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??
Click to expand...

Try,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to report dates in a new tab 2
Counting working days. 6
Arrange data based on two conditions 2
Data selection from one worksheet into a second worksheet. 1
help with datedif function please 5
Excel - digit separation for dates 4
Quartiles in Charts 0
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3

Top