Morning all. I have a base I’m working on that calculates overtime, It also compares the overtime shift worked to an employee’s scheduled shift. I have a set of DURATION fields for each employee - Mon Start, Mon End, Tues Start, Tues End… for all 7 days of the week. Based on the day of the week our OT shift works, it shows the appropriate day’s shift.
I’m pulling the start date of an event from one table (Overtime Events), the employee’s normal shift from another table (Employee Data), and the calculation is in a 3rd table (OT Shift Data).
I’m trying to concatenate the DATE ONLY from when an overtime shift begins, and the DURATION field from the employee’s info, to create one date field I can use for other calculations. None of the date/time formulas seem to give me the results I’m looking for.
Can anyone please offer any advice?