Microsoft KB Archive/138731

= Works FAQ: Spreadsheet Questions (Part 2) =

Article ID: 138731

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Works 6.0
 * Microsoft Works 2000 Standard Edition
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition

-



This article was previously published under Q138731



SUMMARY
This article provides the answers to frequently asked questions about the Spreadsheet module of Works for Windows. This article is Part 2 of 2. For Part 1, please see the following article in the Microsoft Knowledge Base:

138733 Works 95 FAQ: Spreadsheet Questions (Part 1)



MORE INFORMATION
 Q. How can I add days to a date in a Works spreadsheet?

A. To add days to a date in a spreadsheet, create a formula that adds the number of days you want to the date. For example, if cell A1 contains the date 12/25/95, to find the date 60 days later (2/23/96), type the formula

=A1+60

in a different cell. After you enter the formula, you need to format the cell as a date. For additional information about how to add a specific number of days, months or years to a date, click the article number below to view the article in the Microsoft Knowledge Base:

107189 Works: Adding Days to a Date in the Spreadsheet

  Q. How can I total a series of time calculations?

A. To perform the SUM function on cells that are formatted with a time format in Microsoft Works, you must first convert the data in the cells to numeric format.

To accomplish this conversion, create a new column in the spreadsheet and enter a formula that multiplies the time stored in the time/date formatted cells by 24. This converts the time entered in the original cell(s) to an equivalent decimal value; this decimal number can be added correctly using the SUM function. You can use this method for a spreadsheet cell value (or range of cell values), as well as database field values.

The following is an example of how to add a time-formatted column with the SUM function:          Name       Start_Time     Stop_Time     Total_Work --    -     --

Scott     7:00 AM         4:00 PM      9.00 Marty     7:00 AM         4:45 PM      9.75 Jeff      8:00 AM         5:25 PM      9.42 Roy       9:00 AM         5:30 PM      8.50

Total:                                36.67 The Total_Work column contains the following formula:

=(Stop_Time*24)-(Start_Time*24)

Start_Time and Stop_Time can be field names OR cell references.

By multiplying each value in the Total_Work column by 24, the content of each cell becomes a decimal value (for example, 9:15*24 = 9.25), and the new column can be added correctly using the SUM function.

NOTE: The above example assumes that Start_Time and Stop_Time occur on the same date. If the two times are on consecutive days, add 24 to the result to get the correct total.

NOTE: If you format the Total_Work column (column D) with the time/date cell format, the column produces a total greater than 24. Because time can be displayed only in 12- or 24-hour format, the time wraps to 0 (zero) and begins again. For example, if the Total_Work column equals 35:35 when added, it displays as 11:35 A.M. Formatting the column for a numeric format corrects this problem (no wrapping occurs).  Q. How do I add gridlines to my spreadsheet printout?

A. To print gridlines in your spreadsheet, do the following:

 On the File menu, click Page Setup. Click the Other Options tab. Click the Print gridlines option. Click OK.</li></ol>

Works prints gridlines as graphics, which creates a larger print job than text characters. If gridlines still do not print after you make this change, and you have a laser printer, you may need to do one or more of the following:

<ul> increase the physical memory (RAM) in your printer.</li> reduce the resolution in the printer settings.</li> obtain an updated printer driver.</li></ul>

For additional information about problems printing gridlines in a spreadsheet, click the article number below to view the article in the Microsoft Knowledge Base:

111381 Works: Problems Printing Gridlines in the Spreadsheet

</li></ol>

Additional query words: 4.00 4.50 w_works works2k works6 fax facts

Keywords: kbfaq kbinfo kbref KB138731

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.