AnsweredAssumed Answered

Formatted time field in a calculation

Question asked by RyanPontillas on Dec 17, 2013
Latest reply on Dec 17, 2013 by 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-

Outcomes