I've used this:
A B FORMULA IN
COLUMN B
1 Latitude in DD 39.89458898
2 minutes 53.67533862 =(B1-INT(B1))*60
3 seconds 40.5203172 =(B2-INT(B2))*60
4 converted to DMS 39d 53m 40.52032s =CONCATENATE(INT(B1),"d ",INT(B2),"m
",ROUND(B3,5),"s")

you wouldn't need the "d " or "m " or "s" in the concatenate formula if you
don't want or need them, and I wanted the seconds rounded to 5 decimal places
so that is why the ROUND function.

"Chris r" wrote:

im tryin to make a function in a cell and i want to know do i convert decimal
degrees to degrees minutes seconds

thanks