AnsweredAssumed Answered

Calculating Time Range

Question asked by AllegroDataSolutions on Mar 1, 2013
Latest reply on Mar 1, 2013 by AllegroDataSolutions

I am trying to calculate the value of a field named LengthOfStay as per the client's specs. LengthOfStay is a text field with a value list attached, which allows the user to select "Full Day" or "Half Day". If the user does not enter one of these values, it is determined by an auto enter calculation which derives the proper value from their start and end times (the fields TimeStart and TimeEnd). My formula looks like this:

 

 

Case (

IsEmpty ( TimeStart ) and IsEmpty ( TimeEnd );LengthOfStay;

TimeEnd - TimeStart >10800;"Full Day";

"Half Day" )

 

Unfortunately, it always evaluates to "Half Day". Maybe I've been looking at this too long, but I can't figure out what I am doing wrong. Any ideas?

 

Thanks.

Outcomes