Formatted time field in a calculation
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 & "."
"Your audition time is set for 10:30:00 and your warm-up time is 10:00:00."
Thanks in advance for your help.