Recent content by estillbham

I have a format for clients' bills. The first sheet is in portrait mode. The remainder of the sheets are in landscape to allow for tables. The landscape sheets are printed with the head of the page on the right. I would prefer that they be printed with the head of the printed material on the...

I have been given response to a questionnaire in an Excel spreadsheet. There are 12 questions and 25 responses. Because the answers to any particular question range from a few words to a few hundred words, the sheet ends up with a lot of white space. I have tried several ways of formatting the...

SirJB7, yes, the last column is excluded from printing.

Here is a second sample file--this one with data in the Description column. Download it, view it on the screen, then print it. In case it makes any difference, I use an HP OfficeJet Pro 8720.

I created a set of forms to use in creating bills for my clients. I use self-created Google Docs forms to keep up with my time, expenses, and receipts. When it is time to bill the client, I sort the time entries by client, copy and paste them to another form (created by me) in Excel 2010. I...

AVK, The "Boss" data is on similar spreadsheets with the same format. I only sent one sample spreadsheets. Thanks to everyone for the good suggestions.

Chihiro, Thanks for your help.

I have attached a sample sheet with the payroll accounting data for the Workers. The Race Code and the Cost Center (the location) are the important ones. There is another sheet with almost the same structure, except that it has data for the Bosses. An obvious solution I had overlooked is to put...

I read that Chandoo and his family moved to Wellington, New Zealand, in August. Has anyone heard if they are safe after the earthquakes in the last day or so?

I have employment data from a government employer with about 50 work sites. At each work site, there is a "Boss," sometimes an "assistant Boss," and several "Workers" (in the category I am analyzing). I have five years of data -- one year per sheet in each workbook. In the Worker workbook, I...

Jason, Thanks. That works on a new spreadsheet -- if I also set the format to 13:30. But it does not work on my existing spreadsheet. That means there is something peculiar about the formatting or something else in that spreadsheet. Thanks to everyone who has suggestions. Ed

I had tried setting the Time format to 13:30. I just tried something else on a new spreadsheet. Column A is formatted for Text and Column B for Time (13:30) format. If I enter 7:05 AM in A1, shouldn't =TEXT(A1,"TIME") in B2 display at 7:05? Instead it displays #VALUE!

I have a spreadsheet (by someone else) in which one column contains time entries in the format "3:15 PM." When I sort using this column, 3:15 PM appears before 8:00 AM. I tried setting the format of the column as "Time," but that seems to make no difference. I tried using TIMEVALUE(D2) to copy...

I figured it out. The formula should have been =VLOOKUP(B2,Case!$B$1:$C$256,2,0) Google Docs apparently did not display the "Case!". Ed

I am trying to create a new billing system for a friend and am copying my own system as the starting point. The sheet with the same formula does not work. Ed