I often copy + paste data from different data sources into Excel. One field is an hour + minute field (formatted
When I paste the data into Excel hour values of 24 and higher get converted correctly while values of less than 24 get converted into minutes and seconds (see sample data below).
So it appears that Excel is doing some automated conditional formatting based on if the data could be interpreted as time.
Does anyone know how to fix this?
| 22:40 | ←this should be 22:40:00 | 23:25 | ←this should be 23:25:00 | 23:55 | ←this should be 23:55:00 | 23:59 | ←this should be 23:59:00 | 24:05:00 | ←ok | 24:29:00 | ←ok | 24:35:00 | ←ok