Calendar form - calculate time between start and end

  • Thread starter Thread starter aminhirani
  • Start date Start date
A

aminhirani

I need to populate a field with yes or no if the total is more then 14
from start to End. I can do this in excel =IF(B2-A2>14,"Yes","No") and
I am sure there is a way to do it in Outlook.

Any help will be greatly appreciated.
 
The Outlook formula should be something like this:

IIf([Duration] > 14, "Yes", "No")

FYI, there is a newsgroup specifically for Outlook forms issues "down the hall" at microsoft.public.outlook.program_forms or, via web interface, at http://www.microsoft.com/office/com...spx?dg=microsoft.public.outlook.program_forms

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Back
Top