Calculating Speech time in Footer

[pjh21]

I want to be able to calculate the length of a speech I am writing using the NUMWORDS function. To do this, I want to take the number of words in my document and divide by 190 (the number of words spoken per minute).

I'm trying to do so using a table in the footer of my document:

7/28/2017 1:49 PM 3,822 { =B1/190 } Revision: 123

In the table, A1 is date and time of last revision, B1 is the number of words (using the NUMWORDS field code), C1 is the formula I am trying to do to calculate speech duration, and D1 is the Revision #.

The formula I enter just sits there and does not evaluate. Any tips? Thanks!

[macropod]

How did you create the braces (i.e. { })? You can't just type them - they have to be created via Ctrl-F9 or Insert|Quick Parts|Field.

[gmayor]

Note also that neither { NUMWORDS } or { =B1/190 } fields update automatically. As they are in the footer you would either have to open the footer to update them or use a macro. http://www.gmayor.com/installing_macro.htm

Sub UpdateAllFields()
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
lbl_Exit:
    Exit Sub
End Sub

[macropod]

Originally Posted by gmayor

Note also that neither { NUMWORDS } or { =B1/190 } fields update automatically. As they are in the footer you would either have to open the footer to update them or use a macro.

All that's really needed for the calculation to update is a Print Preview. To ensure it updates before printing, check the 'Update fields before printing' option (File|Options|View|Display).

[pjh21]

Thanks both of you so much for the help. I would have died of old age trying to figure that out for myself!

You guys are awesome!