Adding and using function if in the same cell

Hi everyone,

I have this really helpful forum, and I can see there is a lot of very high skilled excel users, however I couldn't find answer I am seeking. I am doing payroll and I wanted to simplify my work. As you can in the picture or file, I have 3 examples there, I managed to count total hours(C2) and hours worked(D2) (minus 30min lunch brake), So my question is: ''How can I do Total Hrs (C2) and Hrs worked (D2) in one cell in this case (C2), I have tried something like:

=(B2-A2)*24,if(C2>5,C2-0.5,C2)

I did tried to search in google(and of cource in this forum) and to watch in youtube, but unfortunately unsuccessful. You can see it works in separate cells, but I would like to know how to do it in one cell. Thank you

Would like to apologize if topic like this already exist.

work.jpg

Thank you AliGW, this is exactly what i meant.

Sorry I have just noticed there is some words missing from my thread. Probably when I edited text.

Originally Posted by AliGW

Which words are missing?

I mean my first post, but it doesnt matter anymore as the problem is solved. Thanks again.