Refer to other cells

Hi,
I would like to know if there is a way to reference date data from other cells.

eg;
I have

Screen Shot 2018-08-09 at 10.39.40 am.png

The reason being, I need to make calculations based on time and date where the time crosses over midnight into the next day, but I don't want to have to put date/time every start and finish cell.
So, from attached example, I want cell C2 to mean 8pm on the 8/8/18 (from A2) and cell D2 to mean 3 am on the 9/8/18 (the next day from (B2))

Hope this makes sense.
Thanks

Using your posted example....
Try something like this:

Please Login or Register  to view this content.

And format that cell as
Category: Time
Type: 37:30:55

Which yields this format code: [h]:mm:ss;@

For your example, that formula returns: 7:00:00

Is that something you can work with?

In E2:

=IF(B2>A2,"Yes","No")

In F2:

=D2*24

However, if you are doing this because of difficulties calculating working hours, then there is a way to do that without the need for these helper columns.

Using this:

=MOD(D2-C2,1)*24

in a cell formatted as a number or general will give you the working hours.

I'm not sure that this solves your problem, but take a look at the attached. You also had a space in the date in B2 which was making it not a date.

Solution as provided by Ron.

Please post the solution in the body of your post as well so that members unable to open attachments can benefit. Thanks.

You're welcome!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.