i need urgent help please

[Guest]

i want to calculate the overtime hours
if someone work from 6 am to 4 pm but the work duty is from(7:30 to 2:30) i
donot want to calculate the time between (7:30 to 2:30), he worked 3 hours
extra but how i can figure it do any one have code for it i can but it in
query or macro because i do not have any idea how i can solve this problem

 

[David Cox]

It may be as simple as:-

Max(end_time - start_time - std_hours , 0)

maybe with (- breaks) thrown in