since I am formatting this field as 12 hour shouldn't it show what the field is showing?
No, because you are formatting only a specific instance of the field placed on a specific layout - while the calculation takes its value directly from the data in the field.
You can either calculate the text equivalent to time formatted as 12 hour, or grab the value from the formatted instance of the field, using the GetLayoutObjectAttribute() function.
FileMaker calculates the time from the number of seconds from midnight in the form of an integer number.
such as 11:11am=40305 seconds.
I tried messing up the formatting in Version 11 and each time it calculated correctly. Maybe understanding what number is used in the calculation will help you. Iam assuming a time field not a timestamp.
Thanks for the replies! I used comment's suggestion of the following...
GetLayoutObjectAttribute ( "num_to_40" ; "content" )
getting the content of my formatted field by naming the object and getting the content.
Thanks for the help!