|
|
#2
03-26-2011, 03:30 PM
|
||||
|
||||
Hi akraw, you can use either:
{IF{TIME \@ HH}< 12 "Night Shift" "Day Shift"} or: {IF{TIME \@ "AM/PM"}= "AM" "Night Shift" "Day Shift"} Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Add a period of time to a referenced "Time" cell?
|
derelyth | Excel | 4 | 03-27-2011 04:31 PM |
| Look up an array based on user input | johnsmb | Excel | 2 | 01-07-2011 01:12 PM |
| server based rules | Babs27 | Outlook | 1 | 01-01-2011 07:21 PM |
|
Selecting merge field based on whether or not text is present
|
amym | Mail Merge | 1 | 12-07-2010 05:14 AM |
| How to refer a field in another field | DaveSmith | Word | 0 | 08-24-2010 06:44 PM |
Windows 7 32bit 
Office 2000
Threaded Mode