|A bit of clarification:|
the value should come in E2 in number format
What kind of number format?
Just changing the cell to a number format will give you the number of days/hours between the two dates with the days as whole numbers and the hours as a decimal fraction so
4/4/2009 9:30 minus 3/4/2009 10:15 = 30.97
What is it your trying to do?
Is it the number of days that is significant?
Is it the number of hours that is significant?
Your statment: but if the time in D2 is more than 6:00 PM leads me to believe your trying to account for some type of overtime, but not sure what your doing.