jayankurian

Time calculation

Discussion created by jayankurian on Mar 14, 2012
Latest reply on Mar 14, 2012 by 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

Outcomes