Well, everything looks dandy, except for that rascally Harpo Marx. Seems he got a little too rambunctious with tooting his horn and found himself working an extra 4 hours doubletime. (Hey, he brings in the laughs, what can I say?)

Basically, I need that line trapped like the other details with just the Employee Number, Name and Date repeated from the previous line.

I had time and messed around and came up with this, is this what you are looking for (some columns omitted)? If so, I just used the row with Harpo's overtime and highlighted the columns with amounts for the detail. I then pulled the rest of the information in an append template.

The first model/project captures and exports to an xls file every row with an employee number and every field on the line. Set the project export to overwrite existing files.

Then the next model/project captures uses the guru trap approach to capture the employee number, name and date in the detail template, using the NNNNN trap for the employee number. Ignore the other numeric values.

Next, the append template uses the same trap and captures only the DT hours. Filter out all the DT fields that are "-----" or blank ("") and you'll be left with a single record.

Now add calculated fields with zero values for every field that is defined in the first model that you created, each field named exactly the same and in the same order as the layout of the first model. Export the table, appending to the file exported in the first project.