[jeff m]

Hello. Is there a relatively easy way to have a formula in one cell show the
product of subracting the time in cell B minus cell A? I know how to do this
in Excel but would appreciate guidance about doing this in Word 2007.
Thanks!
--
Jeff Matranga

[macropod[_2_]]

Hi Jeff,

Yes, provided you've only got one calculation to do. The formula is far from simple though! To see what I mean, check out my
Microsoft Word Date Calculation Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=249902
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Add Or Subtract Two Time Periods'. Do read the document's introductory material.

--
Cheers
macropod
[Microsoft MVP - Word]


"jeff m" wrote in message ...
Hello. Is there a relatively easy way to have a formula in one cell show the
product of subracting the time in cell B minus cell A? I know how to do this
in Excel but would appreciate guidance about doing this in Word 2007.
Thanks!
--
Jeff Matranga

[Doug Robbins - Word MVP]

The easiest thing would be to insert an Excel spreadsheet into the Word
document.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"jeff m" wrote in message
...
Hello. Is there a relatively easy way to have a formula in one cell show
the
product of subracting the time in cell B minus cell A? I know how to do
this
in Excel but would appreciate guidance about doing this in Word 2007.
Thanks!
--
Jeff Matranga

[macropod[_2_]]

Or using text formfields, with the document protected for forms, and an 'on exit' macro to do the calculation and insert the result
into the required cell (eg via another formfield). A suitable 'on exit' macro might look like:
Sub TimeDiff()
With ActiveDocument
.FormFields("Text3").Result = _
Format(CDate(.FormFields("Text1").Result) - CDate(.FormFields("Text2").Result), "HH:mm")
End With
End Sub

--
Cheers
macropod
[Microsoft MVP - Word]


"Doug Robbins - Word MVP" wrote in message ...
The easiest thing would be to insert an Excel spreadsheet into the Word document.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"jeff m" wrote in message ...
Hello. Is there a relatively easy way to have a formula in one cell show the
product of subracting the time in cell B minus cell A? I know how to do this
in Excel but would appreciate guidance about doing this in Word 2007.
Thanks!
--
Jeff Matranga

[jeff m]

Thank you, everyone! Jeff
--
Jeff Matranga


"macropod" wrote:

Hi Jeff,

Yes, provided you've only got one calculation to do. The formula is far from simple though! To see what I mean, check out my
Microsoft Word Date Calculation Tutorial, at:
http://lounge.windowssecrets.com/ind...owtopic=249902
or
http://www.gmayor.com/downloads.htm#Third_party
In particular, look at the item titled 'Add Or Subtract Two Time Periods'. Do read the document's introductory material.

--
Cheers
macropod
[Microsoft MVP - Word]


"jeff m" wrote in message ...
Hello. Is there a relatively easy way to have a formula in one cell show the
product of subracting the time in cell B minus cell A? I know how to do this
in Excel but would appreciate guidance about doing this in Word 2007.
Thanks!
--
Jeff Matranga

.