View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
[email protected] nharris@jacksoncasino.com is offline
external usenet poster
 
Posts: 1
Default Change 60 minutes to 1 hour

I have a worksheet with a several fields that I place in minutes on
projects.
I need to total up the mintues to relect hours.
For example:
A1 , I have 54 minutes
A2 , I have 6 minutes
A3 , I have =SUM(A1:A2)

How do I get A3 to show total of 1 hour?