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" <[email protected]> wrote in message
news:[email protected]...
>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
Bookmarks