Thread: how to add minutes to give hours using excel e.g. 30m +30m = 1hr
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 380
Default how to add minutes to give hours using excel e.g. 30m +30m = 1hr
=SUM(A1:A3)/24/60

and format as time

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"alphonia" wrote in message
...
When I use excel to get a sum of cells. e.g add 30 + 30 +30 minutes will
give me 90 instead of 1 hour 30 minutes. How do I set the cells to give me
the correct sum total?


Reply With QuoteReply With Quote