Turnaround Formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Todd - 29 Jul 2004 21:36 GMT

I have a formula like the one below. I would like to
calculate the time it takes for an account to come in and
when it is actually worked. The formula gives me the
#Name? error. Can anyone help. All of the field names
are valid names. Thanks.
=([dtmDate Worked]+[dtmTime Worked])-([dtmDate Queued]+
[dtmTime Account Queued])

Reply to this Message

macropod - 31 Jul 2004 07:40 GMT

Hi Todd,

Are you trying to do this calculation in Word? If so, you'd probably be
better off doing it in Excel or Access.

If you really want to do it in Word, take a look at:
http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=wrd&Number=249902
(url all one line)
where you'll find examples on how to use field coding for date & time
calculations.

Cheers

> I have a formula like the one below. I would like to
> calculate the time it takes for an account to come in and
[quoted text clipped - 3 lines]
> =([dtmDate Worked]+[dtmTime Worked])-([dtmDate Queued]+
> [dtmTime Account Queued])

Reply to this Message

Rate this thread: