AnsweredAssumed Answered

Time display for value list

Question asked by s on Jul 29, 2012
Latest reply on Jul 29, 2012 by s

FileMaker 12 on OS X

 

I have a repeating field which contains a calculation to return a Time based on the number of the repetition. Every repetition represents 15 minutes, so the first repetition contains 0:00:00 (midnite), rep2 contains 0:15:00, up through rep96 contains 23:45:00

The formula is (Get ( CalculationRepetitionNumber ) - 1 ) * 15 * 60

 

In the table where this field is defined, I can put the field on the layout and set the format to display as hhmm with AM/PM and it looks fine:

12:00 AM

12:15 AM

12:30 AM

...

11:45 PM

 

Next I create a value list from this field, assign it to a global field (of type Time) and format the global to display as hhmm with AM/PM and I get this:

0:00:00

0:15:00

0:30:00

...

23:45:00

 

What am I missing? How do I make the value list display the AM/PM values?

 

TIA

 

--

Steve Moore

Cumberland, Maine

Outcomes