Forum Discussion

gaz1858's avatar
gaz1858
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's avatar
Rich99
Iron Contributor
Feb 11, 2019
Can you give an example of your data?
  • gaz1858's avatar
    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

Resources