View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Convert Minutes into Hours and Minutes

divide by (60*24) and format Custom as [hh]:mm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ...
| So if I have a cell with say 43,238 minutes, I would like to convert
| into Hours and Minutes.
|
| thanks