Formula requesting

[sreekanth kadan]

i want one formula for finding the value . i want to find overtime hrs .

eg: Mr A has 1 day overtime 6 Hrs. but actual his OT is only 2. Because 4 hrs fixed hrs. after above all OT Hrs.
How i can make this automatic

 

[sreekanth kadan]

i want one formula for finding the value . i want to find overtime hrs .

eg: Mr A has 1 day overtime 6 Hrs. but actual his OT is only 2. Because 4 hrs fixed hrs. after above all OT Hrs.
How i can make this automatic

. And also If less than 4 Hrs No OT