Convert Minutes into Hours and Minutes
Hi
Format the result cell, FormatCellsNumberCustom[h]:mm
Use the formula =A1/1440
Excel stores times as fractions of a day, so divide by 60 then by 24 hence
divide by 1440
--
Regards
Roger Govier
wrote in message
...
So if I have a cell with say 43,238 minutes, I would like to convert
into Hours and Minutes.
thanks
|