Formatting Time

[Sammy]

I have a time database that people enter times every day into. It's tedious (I need a barcode solution, it's coming), so it would be nice if instead of formatting time, one could just enter 0600 and FMP would know that you're referring to 6:00am, or 1300 --> 1:00pm, etc. etc.

Is there any way to do this by calculation, or am I stuck trying to find a plugin?

[RalphL]

Use a text field for your input. Limit it to 4 characters. Then use the time function to calculate the time. Time(Left(Input,2), Right (input,2), 0).

[Lee Smith]

Or,

Time(Left(input, 2), Middle(input, 3, 2), 00) and then besure you format your time field to show the AM PM as you indicated in your post.

HTH

Lee