2 Replies Latest reply on Dec 17, 2013 2:51 PM by RyanPontillas

    Formatted time field in a calculation

    RyanPontillas

      Title

      Formatted time field in a calculation

      Post

           Greetings!

            

           I've been racking my brain trying to come up with a way to insert a formatted time field into a calculated text result.  Is this just simply not possible?

            

           To explain - I've imported times in a 10:00:00 format (as they come) but have formatted the field to show them as 10:00 AM. I'm attempting to include this field in a calculation (that ultimately ends up as an email), but it will only insert the non-formatted text:

           "Your audition time is set for " & audition_time & " and your warm-up time is " & warmup_time & "."

           YIELDS

           "Your audition time is set for 10:30:00 and your warm-up time is 10:00:00."

            

           Thanks in advance for your help.

            

           -Ryan-