Here is my sheet. I go out Jan 1 @21:00 and get back Jan 2 @09:00 then
the next day out @09:00 and back in @21:00. Is there a way to write a
formula that will  do nothing if C2 is empty then go to the next Day
( C3 ) and  count the hours for D3? at the same time if i was to go
out and back in like cell B4 on the same day. So i need to have a
formula to work for both in one cell and have it choose which one to
use. Not sure how i would put it. Should i use IF, OR, AND.
this one has me thinking. Who knows it just might be simple. Any
ideas????

    A                B           C               D
1  Date    Time out    Time In    Hours
2  Jan-01    21:00
3  Jan-02        9:00          12:00
4  Jan-03    9:00    21:00    12:00
5  Jan-04    12:00
6  Jan-05        10:00    22:00

Thank you
Leo L'Hirondelle