Degrees minutes seconds

you would need to convert integers to decimal equivalents, i.e

D2: =SUM(A2/24,B2/1440,C2/86400)
copied down, number format as per sample.

Thanks it works but I also need to minus e2-e3 but in this case it shows #VALUE! error how to fix it
.

Originally Posted by goodboy

Thanks it works but I also need to minus e2-e3 but in this case it shows #VALUE! error how to fix it.

I am confused, if you use the suggestion from post #2 to generate Col D you can subtract E3 from E2, result would be 00º 01' 40"

If the above is not correct, post a sample with some desired results.

I don't quite understand the other proposal, from @kv, to store the results as text strings.

Thanks it works.