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

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