Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello - I'm copying sports statistical data from a web source where
one of the elements is time played. When I paste the data in excel it appears as 60:00:00 (and the cell format is listed as [h]:mm:ss). However, the actual data in that cell is listed as 1/2/1900 12:00:00 PM. I've like to be able to use this data to track things like time played, goals per minute, etc., but the format of the cell prevents me from doing this. I've tried changing the format, but nothing seems to be working. Anyone have any thoughts on how I can change this field into more useful data? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert date + time text format to date format | Excel Worksheet Functions | |||
Time format problem | Excel Discussion (Misc queries) | |||
A Time Format Problem | New Users to Excel | |||
how do I format cells to change date and time to just date | Excel Discussion (Misc queries) | |||
Remove time from a date and time field? Format removes the displa. | Excel Worksheet Functions |