=LEFT(C4,2)+(MID(C4,4,2)/60)+(RIGHT(C4,2)/3600)
=LEFT(C4,2)
=MID(C4,3,2)
=RIGHT(C4,4,2)

http://www.rapidtables.com/convert/number/degrees-minutes-seconds-to-degrees.htm