I got a set of data in Excel, like
These numbers actually means hours.minutes. I want to change them in to hours format, eg, 354.31, 354hours 31minutes, change into 354+31/60=354.52 hours. 'cause it's a quite long set of data, I can't do it one by one. Any buddy here knows how to do it in Excel? any formula I can use? Many thanks, |
