View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default adding values and converting the sum to hours and minutes

Hi

Enter numbers as 2:18 & 2:54 in A1:A2, or use Find / Replace to substitute
"," with ":" then

=sum(A1:A2)

Regards,
Per

"rob3108" skrev i meddelelsen
...
Where I am adding values-say 2.18 and 2.54, how to I get the sum to
display
the total as if the values wre hour and minutes i.e. 5.12 hours rather
than
4.72?
Thanks