Customizing Time Formats

[knownothingnovice82]

i'm losing sleep y'all...

Cell a1 has 1:40:35...cell a2 has :45, so selected a1 and dragged the anchor down to a2 and clicked "Formatting Only", but it remained :45. why???

I've tried every "time" and "custom time" cell format option.......no change
any help ray:

 

[steve the fish]

Its because :45 is text not time so time formatting will ignore it.