1 15:06:43

or 1 01:00:54

Where the leading digit is number of days then its hh:mm:ss.

I would like to be able to convert this to either hh:mm:ss or seconds so that for instance the above figures would read

39:06:43

or 25:00:54

Any suggested calculation should be able to work if this figure goes over just 1 or 2 days, for example

4 01:00:54 would become 97:00:54

Please note in the pasted information there isn't a colon between the first digit and the hours and when the time is less than a day there isn't a leading seperate digit of zero you just get hh:mm:ss

I would appreciate any help you can give me thanks.

John.