I need a function that converts bearings into degrees....Are there any such functions?

Example how would i go about converting

S 9 degrees 13' 0" E into an angle

I need this to so I can compute the sine and cosine (the distance is 299.54)

SO in my spreadsheet I need to come up with formulas to spit out this data...

bearing S 9 degrees 13' 0" E
= Decimal form = 9.21666667 (bearing in decimal form)
distance= 299.54

Cos = 299.54 x Cos(9.2166667) = .511792
Sin = 299.54 x Sin(9.2166667) = .85910

ANY IDEAS?