Time format inside IF..THEN..ELSE statement

M

mjaco320

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
 
D

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT

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

--
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time format in Mail Merge field 7
Mailmerge - Replace fields and formatting 1
If -Then-Else Statements in Word 2003 7
puzzling number format problem in conditional field 5
Word MailMerge IF statement not working with hyphens 1
If, Then Else Blanks 3
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements 8
If then else containing value not at the end or in the beginning 3

Top