Thread: how to add minutes to give hours using excel e.g. 30m +30m = 1hr
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
alphonia alphonia is offline
external usenet poster
  
Posts: 1
Default how to add minutes to give hours using excel e.g. 30m +30m = 1hr
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