How do you calculate totals in Word 2000?

C

ChiefNewB

Would like to know if it is possible and if so how to automatically calculate
the totals for a time card template.
 
G

Greg Maxey

CheifNewB,

To automate the calculation you will need to set up your template as a
protected form. You should get a good start here and the linked articles by
Dian Chapman:

http://word.mvps.org/faqs/customization/FillinTheBlanks.htm

You can semi-automate calculations using formula fields and then updating
the fields. Let's say the hours worked are in a column. At the bottom put
the field {=sum(above)}. The field code braces { } are entered with
CTRL+F9. Toggle the field code to display the result with ALT+F9. When a
change is made, you can update the field by selecting the field and pressing
F9, or update all fields by pressing CTRL+a (selects all) and pressing F9,
toggling to and from print preview (if "Update Fields" is checked in the
File>Print>Options dialog box), or running a macro something like:

Sub UpdateFields()
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
oStory.Fields.Update
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
oStory.Fields.Update
Wend
End If
Next oStory
Set oStory = Nothing
End Sub
 
S

Suzanne S. Barnhill

But note that if you're trying to add times, you may need to embed an Excel
sheet instead of using Word's fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top