Thread: ADDING TIMES
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
William William is offline
external usenet poster
 
Posts: 119
Default ADDING TIMES

I would like to add hours in a worksheet to come up with a total number of
hours. However, when I add something like this:

5:00
5:00
5:00
5:00
5:30

.. . . the answer is 1:30. So excel is taking 25 hours and 30 minutes and
representing as 1:30.

How can I get excel to return the total hours total as hours (25:30)?

Thanks
--
William