Excel and Time Values

I am trying to format time values that are in ddd:hh:mm to just minutes. For example, I would want to convert 000:02:17 to 137 minutes. But instead I get Sat:00:02:17 using the following formula =TIMEVALUE(RIGHT(A2,8)) and it gets even worse when itgoes to 23:21:14! It comes out Sat:23:21:14 which should would be 34,380 minutes. The reason for this is am trying gather stats such as median, stdev, average, etc. Is there a way to format these cells to just minutes?

I tried separating 000:00:00 to 000 00 00. Putting it into Access to separate to different column and then bring it back to Excel to multiply days by 1440 and hours by 60 and then adding minutes back into the other two fields….I am sure there was a shorter way!