View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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