Test and analyze evidence in forensic cases

I have the lab's spreadsheet of sample chain-of-custody times, instrument run logs, and analyst reports for case F-492. Verify the formulas that calculate hold times and flag any samples where the calculated time exceeds the allowable limit, then prepare a single sheet listing sample ID, calculated hold time, allowable limit, and the cell reference for the source data so I can show chain-of-custody errors to the lead prosecutor by Wednesday.

Before I send the lab pack to the prosecutor, make it obvious where evidence timing fails the SOP: put the exceedances at the top, show which entries came from handwritten reports versus instrument logs, and highlight inconsistencies in date formats or duplicate IDs that will make a reviewer hesitate to accept our chain-of-custody.

We finished a preliminary review and one analyst's entries for hold times suddenly switch units midway through the sheet; I don't know whether they meant hours or days, the analyst is on leave, and the prosecutor expects a clear explanation. What's the most defensible way to present this to the prosecutor and what should I ask the lab manager to confirm first?

Across several cases I've been the one who finds late entries and corrects time calculations after the fact. I lose credibility when these get discovered by others. Which routines should I change so hold-time calculations and unit consistency are validated before reports leave the lab, and what simple checks will prevent this from being a last-minute firefight?