Hi

I'm trying to convert an entry copied from word into excel and turn it into time. E.g 28.43 needs to reflect as 28 minutes and 43 seconds (28:43) or 64.45 needs to 1hour 4 mins and 45 seconds (01:04:45) , I then need to identify those individual entries under 5 minutes.

Any help would be most appreciated

Thanks