Date Translation and Logic

[meppwc]

I am having a hard time getting something to work

This is a two step process using date/time logic

First Step - Date Range 1
In A1 I will paste a date and time in this format. "10/23/2015 12:05 AM" (without the quotes)
The value in A1 is Eastern Time
In A2 I need a formula that translates the A1 value into Central Time
I need the same formula again using B1 to paste the Eastern Time value of "10/28/2015 11:55 PM" (without the quotes)
And B2 will be translation of of B1 Eastern Time into B2 Central Time
I want the values in A2 and B2 to keep the same format as A1 and B1

The end result is A2 will be my CT Start Date/Time and B2 will be my CT End Date/Time


Second Step - Date Range 2
In C1 I will paste a date that is already in Central time with the format of "10/24/2015 9:00:00 PM" (without the quotes)
In D2 I will paste a date that is already in Central time with the format of "10/26/2015 9:00:00 PM" (without the quotes)

So now I have a established a Date Range 1 and Date Range 2 that are both in Central Time and all the same date format.
So the last step is the need for a formula in E1 that provides True/False type of logic.
If any part of the date/time range for "Date Range 2" falls within the "Date Range 1" parameters, then E1 is True, if not, False

[ChemistB]

In A2 copied to B2
=A1-"1:00"

[ChemistB]

Clarify Part 2 for me. So if any part of the time between C1 and D2 falls between A2 and B2, then true?

If So

=OR(AND(C1<A2, D2>B2), AND(C1>=A2, C1<=B2), AND(D2>=A2, D2<=B2))

[meppwc]

I think you lost me

[ChemistB]

I lost you? How so?

[meppwc]

I am sorry..........I was just confused on how you explained the first step...........yes, this works perfectly, thanks so much

[ChemistB]

Glad to help.