Calculate number of days between two dates and time

Please help I have a glitch on my formula when I calculated the number of days that had a grace period of 32 minutes. After 32, it should round up to 1 day. see attached file.

340997d1408911932-calculate-number-of-days-between-two-dates-and-time-no.-of-day-calculation.xlsx
Try this:
=DATEDIF(A7,B7,"d")
=DATE(YEAR(B7),MONTH(B7),DAY(B7))-DATE(YEAR(A7),MONTH(A7),DAY(A7))

Hi vogel997,

First, I would like to thank you for helping but when I tried and the formula does not work for the time that exceed 33 minutes between check in/out time. For example, the below 6/23/11 21:52 and 6/27/11 22:56 is 48 minutes (56-8) that exceed 33 minutes and I would like to the result it round up to 5 days

Should = to Formula
DateOut DateIn # of Day Return
6/10/11 17:33 7/6/11 17:52 26 27 Not working 26 26
6/26/11 10:58 6/29/11 11:19 3 4 3 3
6/26/11 10:52 6/29/11 11:21 3 4 3 3
6/21/11 18:16 6/27/11 18:24 7 7 6 6
6/23/11 21:52 6/27/11 22:56 5 5 <-- four days and 2 min?? Should be 5 days because it's over 33 minutes 4 4
6/24/11 11:01 6/28/11 11:03 5 5 4 4
6/20/11 13:46 6/28/11 13:48 9 9 8 8


Revision
5/11/12 12:01 5/14/12 13:12 4 3
5/8/12 10:42 5/15/12 12:32 8 7
5/9/12 10:44 5/16/12 12:15 8 7

Fantastic! both formula from daddylonglegs and vogel997 is working great.

Thank you so much.

hi all,

I have a query,, i need to calculate the last 7days data for calculation, based on date. need formula for this.

regards
Shukur

Do you have a sample that we are able to help? Have you tried the formula from daddylonglegs and vogel997