Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-26-2011, 03:30 PM
macropod's Avatar
macropod macropod is offline field value based on time of day Windows 7 32bit field value based on time of day Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,375
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
field value based on time of day 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
field value based on time of day 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft