I am trying to get various totals out of data which I have had to copy and paste into Excel from another application, however the hours figure comes out strange if it goes over a day such as
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.
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.