Forum Discussion

Copper Contributor

Feb 11, 2019

Removing Days from dd:hh:mm:ss Fields

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. I...

excel

office 365

Rich99

Iron Contributor

Feb 11, 2019

Can you give an example of your data?

gaz1858

Copper Contributor

Feb 12, 2019

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