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
|