Forum Discussion
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...
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
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
It looks like you have texts in form of time. When you may use
Yes it seems that way. Thanks Sergei
