John Jason Jordan wrote:
On Sat, 25 Mar 2006 22:23:06 -0800 John Jason Jordan
<[EMAIL PROTECTED]> dijo:
OK, this is ridiculous.I have spent hours on this five-page Writer
document and can't get the formulas to work at all. Part of the
problem is that I can't find any documentation. Where is the Help
file for formula syntax? Like, if I want to sum cells C2 through C6,
and C8 through C11, and C15 through C25, how do I write that? No
matter what I do I get bizarre results. No error messages, just the
wrong totals. There must be something fundamentally wrong. I've asked
three times hear and got only one reply. I have to send this off
tomorrow and I have no more time left to fiddle with it. Someone
please HELP!
I think your formulas aren't the problem. It's the format code.
Use the format code [HH]:MM in your total cell. The square brackets will
let the number of hours go up to 99. I suppose you could use [HHH]:MM if
you need more that 100 hours.
--
Rod
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
