| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting Standard Time to Military Time in Excel | Excel Discussion (Misc queries) | |||
| formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
| Problem with converting decimal time to hours and minutes | Excel Discussion (Misc queries) | |||
| Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
| Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
Threaded Mode
