View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Adding Time (hours and minutes)

On Mon, 4 Jul 2005 22:12:48 -0400, "William Benson"
wrote:

Hi Ron, great formula!

I got the value 0.777778 in the sum....just wanted the OP to know he might
need to reformat the result cell as time.

Bill


Thanks for adding that.
\
And the format he should probably use would be [h]:mm in order to get hours
over 24.


--ron