text to time with only minutes & seconds

[gmazza76]

Good morning,

I have pulled information from one of the systems I use and the time is coming up as "26:57.0" (mintues:seconds:milliseconds" instead of the "hh:mm:ss". How do I convert this into a time value as I need to minus this from another column in the same format so I can work out time lapsed.

I am using PowerPivot currently to do some analysis.

thanks in advance.
Gavin

 

[Sufiyan97]

Post your sample data using below link