Removing Days from dd:hh:mm:ss Fields

[gaz1858]

A report provided by one of our suppliers gives us times in dd:hh:mm:ss format. When I try to add these together, Excel will only do it if i remove the dd part and convert the format to hh:mm:ss. 

Is there an easy way of removing the dd part across multiple cells? Up until now I have been manually going in and deleting it which isn't manageable.

I have attempted just formatting the field/s in question but nothing happens.

Thanks in advance

[#2]

Can you give an example of your data?

[#3]

If you'd like to show only time part, it's enough to remove dd: part in format.

If you'd like to sum all times ignoring the date part you may use the formula like

=SUMPRODUCT(A1:A200-INT(A1:A200))

applying [hh]:mm:ss format to the result

[#4]

Here is the data as it is delivered to me. The only way I can get the times to add up is to manually go in and remove the initial 00: '

Even using the other persons suggestion below did not work until i removed these zeros

[#5]

Thank you Sergei,

I have given this a try however it only worked when I removed the initial 00: manually again.

I have attached a pic of the data as it is delivered to me on a seperate response to see if that helps with any solutions

[#6]

It looks like you have texts in form of time. When you may use

[#7]

Yes it seems that way. Thanks Sergei