Excel 2007.



I have ran a query in SQL and copied it over to Excel.

I have 2 columns.

The first is a "received date" and the second is a "completed date".

The format for the receive date looks like this: 09/27/2011 0:00

The format for the completed date looks like this: 09/28/2011 10:49

I am trying to calculate turnaround time base on these rules:

Ignore the time stamp.
If the receive date and the completed date are the same, the turnaround time will be computed as .5 days.

So in the example above, the turnaround time is 1 day.

Can somebody give me a quick formula to calculate this please?