6 Replies Latest reply on Mar 14, 2012 1:30 PM by jayankurian

    Time calculation

    jayankurian

      Time calculation issue

       

      My fields

      1. Accession TimeStamp: 7/1/2011 1:50 AM
      2. Accession Time: 1:50 AM (which is the calculation result – Right ( Accession Timestamp ; 8 ) Result is in Text

       

      Trying to create the following calculation field and it is not working.

       

      3. Tour I: If(Accession Time >= 00:01 AM and Accession Time <= 08:00 AM ; “Tour I” )

      ( Unable to save the calculation.)

       

      3. Tour I: If(Accession Time >="00:01 AM"and Accession Time <=08:00 AM ; “Tour I” )

      (able to save the calculation, but no result)

       

      Please tell me "What I am doing here wrong?"

       

      Thank you