Changing decimal to mm:ss format Excel

Question

I have duration in decimal format in excel, e.g. 35.78 minutes, which I wanted to change to minute/second format so e.g. 35.78minutes becomes 35 minutes 47seconds in excel. Any way I can format it that way? I have tried the custom filter of mm:ss but that does not work

Answer 1

You need some math operation to convert decimal values to time values. Try-

=(A1/24)/60

Then format the cell as mm:ss

Or direct formula =TEXT((A1/24)/60,"mm:ss")