How to Calculate OverTime,Full_Day,Half_Day,Late_In,Hours,

Question

i have INTIME and OUTTIME of employee ,

INPUT

 

EmpID	IN TIME	OUTTIME
2000092	2018-05-24 09:20	2018-05-24 21:00
2000090	2018-05-21 08:00	2018-05-21 20:00

 

OutPut

 

Hours(A)	Starndard Hour(B)	(C) Over Time(A-B)	OT Rate(D)	OT Amount(C*D)
11	8	3	100	300
12	8	4	100	400

 

i want this output in same table by sql query...Kindly guide