|If you are using separate Date & Time cells I would advise against it.|
Combine both Date & Time in one cell, it will make your life a lot easier.
What your doing now is subtracting 7:00am from 7:00am which of course
That's because the formula does not know that one 7:00am
is on a different DATE then the other 7:00am
If you must keep the date and time seperate, then modify your formula to
check for the date first.
If your data looks like:
E F G H I
17) 6/8/2012 7:00 6/9/2012 7:00
In cell I17 use the formula:
Note that we check the DATE cells to see if we
need to add a day.
Format cell I17 as General or Number.
See how that works.