View Single Post
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

Use a formula like

=A1/24/60

and format the cell for Time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"gyrkin" wrote in message
...
I need to convert a number stated in minutes into a format that
reflects
Hours and minutes.
As an example: 722 minutes = 12 hrs 2 mins