Add day after midnight

[ajitexcel]

What i m trying is to have number of days elapsed if end time crosses midnight...
for example
there are three column of data
A1 - Start Date/Time
B1 - End Date/Time
C1 - Total days

A2 - 01 Mar 10 08:30
B2 - 01 Mar 10 21:00
C2 - It should be 1 (as it is the same day or first day)
But IF B2 - 02 Mar 10 09:00 then C2 - should be 2 (any time after midnight of 02 Mar till midnight of 03 Mar and after that it should increment by one day.

hope the example help's in understanding the problem...

[Paul]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!