View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Adding up hours and minutes

Hi,
I need to add up a list of hour and minutes, the only problem being is that
Excel treats them as TIME not hours and minutes.

For example, if I sum 7:24, 7:24 , 7:24, 7:24 [ where 7 = hours and 24 =
minutes ] then Excel five me an answer of 05:36 rather than 29.36 - any ideas
how I get this working ?

Thanks