Formating dates

[Guest]

I have dates and times in 2 cells(a1 and b1). How do I format an other
cell(c1) to tell me hiow many days there is between cells (a1 and B1).
Thanks
Ian

 

[Peo Sjoblom]

=B1-A1 format as general (end date - start date)

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[Biff]

Hi!

A1 = start date/time
B1 = end date/time

=INT(B1)-INT(A1)

Biff

 

[Peo Sjoblom]

Oops! didn't read far enough, see Biff's answer

Peo

 

[Guest]

I guess I did not explain well enough
In A1 I have Wed 12 Apr 2006 01:46M
In B1 I have Tue 11 Apr 2006 04:41MTThat give me an answer of 21 hrs 4
min and a few seconds.
What I really wnat is the number of days(in this case it wouod ab e about
..8(point 8)
How can I do that
Thanks

 

[Biff]

As long as these dates are true Excel dates then just subtract:

=A1-B1

Format the cell as GENERAL

Result = 0.878472222218988

Biff

 

[Guest]

Worked Great Thanks

As long as these dates are true Excel dates then just subtract:

=A1-B1

Format the cell as GENERAL

Result = 0.878472222218988

Biff