i need urgent help please

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
It may be as simple as:-

Max(end_time - start_time - std_hours , 0)

maybe with (- breaks) thrown in
 
Back
Top