Thread: Convert Minutes into Hours and Minutes
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Convert Minutes into Hours and Minutes
=A1/60/24 and format as [h]:mm
--
David Biddulph

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

thanks


Reply With QuoteReply With Quote