Converting Lat/Long (Degrees Minutes Seconds) to Decimal Degrees

Does anyone know how to convert Lat & Long from the DDMMSS to decimal degrees without doing each one manually?

An example of the input data is:

12°35'36'',00 and I need to get the decimal equivalent out.

Cheers

Jez

Hello Jeremy Rayne,

Have a look a Chip Pearson's site...

Latitude and Longitude in Excel

Sincerely,
Leith Ross