Thanks for that, although I have already tried just the HH:MM format but without any use, I'll try the DD:HH:MM but I could really do with it being only hours and not days as at a later part the total has to be divided by a figure of (at the moment 3).
Basically it will be the motoring mileage between multiple points across Europe (A to B, B to C, etc) of which at the moment the total initially will be about 10 different points spread over 1,800+ miles which is to be travelled over 3 or 4 days.
Basically it's easy to copy the figures over from any of the maps being used and quicker than typing them but the formulae is needed to add them all back together.
Warning - while you were typing a new reply has been posted. You may wish to review your post.