Complicating excel formulas

[EXCELenpz]

Hello

I want to create a spreadhseet to work out each workers different working hour based on the tart time and finish time entered with breaks included if there is any.
For example: Jon Doe working 6:30 - 10:30 with a break of 30 min.
I want to apply the code for each workers based on their names with a code of the lunch break, depending how long has that been.
I was thinking of the formula to exchange the data from another sheet, entering each workers code for each break. How can I make this simpler?

 

[Scott Huish]

You mean like each break has a code based on length, then maybe this:

Book1
	A	B	C	D	E	F	G	H
1	Name	Start	Break Code	End	Total		A	0:30
2	John Doe	10:00 PM	A	1:00 AM	2.50		B	1:00
3							C	1:30
Sheet1

Cell Formulas
Range	Formula
E2	E2	=MOD(D2-B2-LOOKUP(C2,$G$1:$H$3),1)*24