I have a .csv file that is populated with hours (for example 28:53 when open
as text file)
When I open it in excel it automatically formats any hours that exceed 24:00
as a time & date (for example 28:55 imports 01/01/1900 07:54:00, and when I
format it as [h]:mm:ss it displays 31:54:00)

If the data reads less than 24:00 ie 18:45 it will display 18:45

How caN i COEERCT THIS?