Converting Degrees/Minutes/Seconds to Decimal Degrees in Excel

To convert DMS values to decimal degrees (e.g., 45:30:30 to 45.50833), multiply the DD:MM:SS value by 24, and format the cell as General. For example, =A1*24