Put this in C1 =ROUNDUP(B1-A1,0) and copy down. Format column C as Number
with no decimal place. Col A & B should have dates with time.

Let me know how it goes.

"Abee" wrote:

I want to know the formula for calculating the below mentioned problem
col A B C
1 10.8.08 11 AM 11.8.08 3PM 2days ( i need formula here)

We have a small inn and i need to calculate the duration of stay by a guest.
Checkout time is 24 Hrs. The Column C should display 1 if the duration is
less than 24 Hrs and it should display 2 if its more than 24 and less than 48
and so on. PLEASE HELP