Hi, I'm a newbie so forgive me if this is easy. I am trying to format the time field in a layout. I went to the options in the field property and set it to "hhmm" with a ":" separator. It is showing up "1535:00". I don't . I have the other settings to 'none'. I can't figure out how to make it look lik e"15:35". Got any ideas?

You have to enter "15:35"; if you enter "1535", Filemaker assumes that are 1535 hours.

Hi Vandy,

Go to Layout Mode, click on the field and then go to Menu, Format, Time.

In the dialog menu that will appear, the Option to change this is 2nd one called: Format As:

It's a drop down menu.

HTH

Lee

Hi. I changed it to "hhmm", but it still is formatting funny. By the way in response to Bruggmann, I want the user to be able to type in t"1535" and have the computer automatically put in the ":" separator. So it says "15:35". If you can't get it to format this way, will is still work in find and query situations? ... the 1535?

Vandy,

You don't have a profile showing what FM version you're using. It may be possible to have FM7's auto-enter calc option "correct" the input you're describing so that it will adjust what *seems* to be a number of hours (on FM7's way of understanding time input) so that it will count instead as hh:mm.

Sorry about that. I use FM Pro Dev 7. But I will need to use the time field in finds (for instance, give me all the things that happened between x and y... or how much time has expired between x and y... so that's the most important thing, the format is only the icing.

Thanks

Vandy

You may want to display a calculation time field like

Let( x = Right( "0000" & pseudotimefield; 4 ) & "00"; Time( Left( x; 2 ); Middle( x; 3; 2 ); Right( x; 2 ) ) )

on top of your pseudotimefield (with a solid background fill and formatted as hhmm), and only allow entry to the pseudotimefield. Then you can enter 1535, see 15:35, and search for 1535, assuming of course that you've formatted the calculation field on the layout as 24 hour time.

ESpringer said:

It may be possible to have FM7's auto-enter calc option "correct" the input you're describing...

Yes. I believe that Elise is on the right track here. There should be no need for stacking fields.

Attached is an example which shows how one might go about it.

TimeTrick.zip

Hmm, I thought the desire was to enter and find normal number fields, but format as time. Hence the need for stacking and not overwriting the original number. I think I misconstrued a few of the posts.