date/time difference

[lee009]

I am having trouble finding the 'split date' between 2 dates/times. My data does not export together, meaning I have a date field, time field, date field, time field.
Example:

From Date From Time To Date To Time

so I used "=a1+b1" and the same for the next columns. Now what I want is the split date.
Example: (after combining my columns)

From Date/Time To Date/Time
1/1/2018 24:00 1/1/2018 08:00

What I want for the split date is 1/1/2018 04:00 but I can't figure out a formula to get that.

 

[SpillerBD]

From Date/Time To Date/Time
1/1/2018 24:00 1/1/2018 08:00

Despite the error in the presented data, it looks like the average of the two date/times is all you need.