How do I calculate this time? Across midnight

Question

I have a sheet with start and end dates and values.

In C I have start date.
In E I have end date.

In I I have start time. (06:05:00)
In J I have end time. (08:33:00)

If C <>E I need to add 24 hours to the time elapsed.

How can I do that?

I tried if(C2<>E2;1+J2-I2;"omitted") But I get the result 21:32:00.
It should be about 26 hours
(24+8-6 = 26 if we only look at the hours).

What have I done wrong?

Edit;
Back at work and can now upload some images.
Method 1

Method 2

Both return the wrong time.

EDIT2;
Method 3
I remember how I always have to format the dates from "our" format to Excels format for it to be recognized as a date.
In column P I use RIGHT(), MID(), and LEFT() to make a correct formatted date.
In R and S I use the same as P&Q column.

Still not correct.
:-/

EDIT again:

Answer 1

Use formula: =(E1+J1)-(C1+I1) we just add the date and time together and subtract the end from start and then format the cell having the formula to show days, hours, minutes.

This way, if you have more than 1 day difference, you're not just adding 24 hours.

Change the format of the target cell contianing the above formula to d "days" hh "hours" mm "minutes" or use the format tigerAvatar suggested of [hh]:mm if you want the hours to be cumulative across days.

Then you get a nice output of: 2 days 02 hours 28 minutes or 50:28

Feel free to drop the 1 h or 1 m if you don't want the leading zeros.

A picture is worth a 1000 words so:

Version 2 after your screenshots: I don't think C, E are in date format based on your updates so... I used formula=(DATE(LEFT(E2,4),MID(E2,5,2),RIGHT(E2,2))+J2)-(DATE(LEFT(C2,4),MID(C2,5,2),RIGHT(C2,2))+I2) in K and custom format mask: [h]:mm If this doesn't work it may be a regional setting and the interpretation of [h]:mm I am assuming I/J are time formats.