I'm trying to use the data in a pivot table and the information is entered into one cell as dd hh:mm:ss. How would I break this out if I wanted to manipulate the data, would it be with a pivot table or formula? I have two columns next to each other with dd hh:mm:ss format with different times and I want to calculate the time elapsed between them. Anything helps!