Calculating Speech time in Footer

pjh21 · #1 07-30-2017, 09:13 AM

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 · #2 07-30-2017, 04:01 PM

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 · #3 07-30-2017, 07:58 PM

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

Code:

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 · #4 07-30-2017, 09:21 PM

Quote:

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 · #5 07-31-2017, 09:19 AM

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!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calculating convoy time elements	reithj	Excel	3	06-09-2016 10:01 AM
Speech Mark problem.	voyagerone	Word	9	02-02-2016 10:58 PM
Calculating Average Time across days	lizakay	Excel	3	11-25-2015 05:16 PM
Calculating Turnaround Time	shstone	Excel	4	12-11-2014 12:39 PM
Speech plug-in for PowerPoint	Brytni Boyd	PowerPoint	4	05-19-2010 09:39 AM