View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pranav Vaidya Pranav Vaidya is offline
external usenet poster
 
Posts: 180
Default Convert Minutes into Hours and Minutes

Hi,
Suppose your data is in cell A1. Now type this formula in cell A2

=A1/60

Then select cell A2 and change the format of this cell to 'Time'.

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


" wrote:

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

thanks