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
|