This is the data I have from another program, exported to Excel. 9h 3min 26sec I have tried to format the column to display it as only hours and minutes but it won't convert. I have 3616 lines of this that I need converted to hours and minutes and I'm at a loss. Any suggestions would be greatly appreciated.
Solved by I. H. in 27 mins