View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Randi Randi is offline
external usenet poster
 
Posts: 28
Default Concerting total minutes to hours and minutes

I have a column of minutes which totals 500 minutes.
I want to convert it to hours and minutes. What formula
can I use to get it to the 8 hours 20 mins. Also what should my
cells be formatted as? Is there a way to bypass the total minutes all
together and have it compute directly into the 8 hours 20 mins? Thanks.