Time Format

Hi,

I need again excel formula assistance and i know you guys always do.

Attached is my sample file. I need to have a formula wherein the "Duration" column will be converted to decimal numbers. The problem is, there are numbers that supposed to be in mm:ss format but is read as hh:mm in the data. So, the other time in which in hh:mm:ss where treated as the same with mm:ss.

I need to have a distinction that those seen mm:ss should not be treated as hh:mm.


Looking forward again guys!


Thanks.
Marnie