Why does the user need to edit this field?
It would appear that you have defined this field as a calculation field. The contents of a calcualtion field cannot be directly edited and thus you get this error message.
Your options are to:
Don't try to edit this field, either edit a different field that becomes part of this calculation's expression or don't try to modify it at all.
Make this field a text field with an auto-entered calculation instead.
I am trying to make the field as a calculation field. The "drop" down menu was left over from when it was a manual entry, but our ISO auditor does not like it being manual. She wants it the field to be Automated. I captured the Drop down options to help decribe what I am trying to achieve. Ie, Help Desk response less then 60 mins the HD SLA Response Met: would = Yes
Then you should remove the drop down formatting and not permit access to the field. Then you will not get this error message.
Your calculation, on the other hand, should be:
If ( HD Response Time - Help Desk Ticket Time < 3600 ; "Yes" ; "No" )
You can use Case instead of If if you prefer.
The difference between two time fields will give a result in seconds so you compare the result to 3600 seconds instead of 60 minutes.
Your soltuion fixed my problem but creates a different issue. Say the ticket is "Opened" at 14:00 and the help desk responds at 14:40, Good to go your solution works perfectly. Same thing if they do not respond for over an hour. I get the correct response (No). The issue is, if someone puts in a time before the ticket time. IE: Ticket opened at 14:00, the the time entered for response is 03:00. The auto answer says "Yes". I suspect it is because the answer is correct numerically just not really with regards to the clock. Does that make sense?Thanks for all your help by the way.
why would the response time be earlier than the open time?
If this time represents 03:00 of the next day, you should use time stamp fields to record the date and the time for each of these two events. TimeStamp fields can be subtracted just like time fields and the result produced is still in seconds, but the change in date enables the calculation to still correctly compute the elapsed time when midnight falls between the two recorded time values.
You are the man! Thanks for all your help!