Convert a decimal time value to minutes and hours in Excel easily by dividing by 24 then changing the cell format to h:mm.
excelsemipro.com