I found in the forums a way to enter time as example 1300 and fmp changes it to the proper time format of 13:00 and what I tried was

Replace ( Right ( "0000" & Timefield ; 4 ) ; 3 ; 0 ; ":" )but when I put it into my db it says it cannot find "timefield";4). I am wondering if this is because I am using FMP 6 although I can't really see why it shouldn't work. Any help on this?

Thank you

What is the name of the field that has the time value? That is what you need in place of "Timefield" in the calculation.

Thank you for the quick reply. I did put the actual field name in the "Timefield". It is called Time In field from my database but it still won't let me use it. Should I change my field Time IN to a calculating field or leave it as a time field and use option auto-enter using a calculation?

Thanks again

For one thing, you must use commas instead of semi-colons. For another, this won't work in version 6, because it has no auto-enter replacing existing value. You need to use two fields: one for entry (could be a text field, if you prefer to enter time in a non-standard way) and another for display (a calculation field with result of type Time).

I guess I will just wait until we upgrade which I hope is soon. Thanks so much for your help

I'm sorry, didn't see the FM6. Btw, the upgrade from FM6 to FM10 won't be trivial. Depends, of course, on the complexity of your system.