Unanswered: datediff function to include lunch breaks automatically
I have a database that calculated project costs. In this calculation is labor cost. For total time im using this datediff function to give me total hours worked.
My problem is it does not include there lunch break which is always at 11:00am. I thought I could use an IIF statement that if end time is greater than 1100 subtract an hour but they could start and finish multiple projects after 11:00am so this would cause multiple subtractions. Anyone have any suggestions?