View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default how do i convert minutes to hours

Hi Miriam,

If the minutes are supplied as a number (of minutes):

=A1/24/60

Format as Time

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"m fournier" <m wrote in message ...
|I have a spreadsheet that was forwarded to me in minutes but I need to covert
| these minutes to hours ie 74 minutes should be 1:14 minutes.
|
| Any suggestions?
|
| Miriam
|