Time format inside IF..THEN..ELSE statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mjaco320 - 23 Jan 2004 01:06 GMT

Greetings!

My document (Word 2002) contains a merge field which is formatted (from within Access 2002) as "h:mm" and it has retained its format in Word. I need to include an IF..THEN..ELSE statement which evaluates if the mergefield value is less than "5:45" and then returns the appropriate text.

I tried transforming 5hrs and 45min. to it's stored value of .23958833333, but that did not work. If the merge field is not formatted and merges as the numerical equivilent, the IF statment works just fine. However, I NEED to have the merge field formatted.

Any thoughts would be greatly appreciated.

Marc
New Student Programs
Radford University

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 23 Jan 2004 08:43 GMT

Use Access to do the data manipulation. It's far better at it than Word.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

> Greetings!
>
[quoted text clipped - 14 lines]
> New Student Programs
> Radford University

Reply to this Message