calculate time spent working but ignore a set break period

Hello, I made a account just to ask this question.

I want to do a sort of work table showing the time I started and the time I finished with a 30 min break in the middle for example, which then calculates the total time worked next to it taking away break time, I'm a novice.

Here is a example.

This is in time;

Start Lunch End Time spent working (hours)
09:30 13:00 15:00 Time goes here.

hi The man2 unfortunately
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Originally Posted by martindwilson

hi The man2 unfortunately
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I don't quite know what to call it...

So any help on the actual problem at all?

not allowed to it will only get deleted by a mod
Need help with Time tabling + formatting.
change to something like
calculate time difference but ignore a set break period

well assuming lunch is 1/2 hour and its always between the times and always 30 mins and if you dont have lunch the cell in col b is blank
=(C2-A2-IF(B2="",0,"00:30"))*24 cell formatted general
ps

but that's rather silly

but you did agree to rule 1 when you joined the forum

i dont know what cells you are using
see mine