Turnaround Formula

T

Todd

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])
 
M

macropod

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


Todd said:
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])
Click to expand...
 
Top