View Single Post
  #1   Report Post  
Ash87 Ash87 is offline
Junior Member
 
Posts: 1
Default Problem converting Time

Hi there,

So the national hockey league has a statistic known as Time on ice which is reported in minutes and seconds, on websites it is reported mm:ss. For example, one player might play for 12:23 or 12 minutes and 23 seconds. However, when I copy and paste these stats into excel, it think it as a time like 12:23 PM. How can I change this to 12 minutes and 23 seconds?

Thanks
Ash