Thank you for responding. I did post a lik to the sheet. I posted it to the user forum and I am investigating that I might have my times in formats that are not clear. Hence my data isn't displaying correctly. Congratulations on your recent accomplishments.
John -----Original Message----- From: CPHennessy [mailto:[EMAIL PROTECTED] Sent: Saturday, May 06, 2006 10:04 AM To: [email protected]; John Toliver Subject: Re: [users] Can't get figures to reflect correctly in Calc On Wed May 3 2006 02:05, + John Toliver wrote: > I am using Open Office 2.0 on windows xp > > I am trying to create a spreadsheet which totals my work hours for a > two week period, and then shows me what my gross pay and total hours > will be for this period. I want each table to be duplicated four > times on the sheet. Then I want to create 12 sheets, one for each > month with 4 tables and a final that will give me year totals I can > use when I am doing my taxes. > > So basically, I am just making extensive use of the "sum" function in calc. > The first problem I run into is that on the template I am editing, > when I change the weekly total column to "sum(mtwtf)" it won't display > on the sheet itself. The sheet returns zero but when I go to the > function wizard to check my input, it calculates it properly so I know > wht I entered is correct(I put in some dummy totals to make sure the > functions worked). I went hunting for a "refresh button" and didn't > find one so I'm confused here How can I make the spreadsheet display > the totals properly? I also find that I am unable to get the data to > reflect properly when I try to say in an adjacent cell: > ("sum(<week1totalhours>;<week2totalhours>")=total > hours for pay period and then in another cell say: > (<payrate>*<cell_with_total_hours_for_two_weeks>)=gross pay for pay period. > > > > I believe that if I fix the first then the others will then start > updating properly. The help says I am doing it correctly but I can't > make it reflect. > If this helps, I have the total hours for each day calculated also and > this displays properly. and I base my other formulas off of this basic input. > Anyhelp would be appreciated and if this doesn't make sense, I will > rewrite this differently to be more clear. As you are not subscribed you may not have seen that: On Wed May 3 2006 11:27, Dan Lewis wrote: > > Would you please post this speadsheet on the web and send its address > to this mailing list? Include some data in it also. Then several > people can look at what you have and suggest changes. Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
