Check one thing. In the clock in column, when you click on the cell d2 (based on your sample data)
do you see a the top value as "8:08 AM" or do you see it like 8:08:00 AM. Again not the the cell but the top in the formula bar
When I imported your example, though the cell seem to show the value as "8:08 AM" but actually if i look at the formula bar, it appears as 8:08:00 AM.