@scott truncateTimeColumn() helped with a few things. and it is also a more straightforward answer to the normalizing problem.
Thanks to your help I am satisfied that my two questions have been answered.
- Yes, it’s a reasonable solution
- I got excellent advise on optimizing the solution.
