All good ideas but al clumsy me thinks! No better than the initial post (sorry noted).
Anyway, have tried a few variations on a theme, but guess what, I am also getting funny returns for some values from Excel!
Noted - I will persevere.
Perhaps you can drop me a copy of the worksheet/workbook so I can see how you are working today (format wise etc).
I think the only (solid) solution is going to be a little
VB code in there to provide a sexagesimal/decimal conversion/sum/re-conversion.
Guess I am already looking forward to the week-end now!
