Nested If Statement using Time formatted cells

[tcowen61]

I've searched through about 4 pages of threads with "time" in the title but cannot find an example of this situation.

I am trying to build an if statement to test variables that are in time format and then perform a calculation.

I was able to get an example working if I convert the start times to integers rather than time values. However, the data won't be provided to me as integers.

So, I need a nested if statement (using "and") that will test for two situations using cells in time format or I need to write a macro to convert the time data to integer format. I've been working on the former most of the day and have hit a brick wall.

Can someone take a look at this and offer a solution or perhaps something I haven't considered.

Thanks