Pretty much to condence the information.Going to use these work sheet, pivot it. and use it as a better work sheet..

I there a problem with the file or times in the dates? do i need to format them?
do i need to add a zero to the blank to pivot this?