Student has guitar class on Monday at 13:00. I have fields for instrument, day of week and time of day (time field). I can format the time field to show only hours and minutes, great.

When I make a calculation  field to show--- "Your (instrument) lesson is on (day of week) at (time of day)" --- hours, minutes AND seconds show up again in the time of day. How do I get rid of the seconds in this calculation?

You can do your own formatting =

Hour ( Timefield ) & SerialIncrement ( ":00" ; Minute ( Timefield ) )

 

Alternatively, if this is on the same layout, you could "steal" the already formatted time as displayed in your time field  =

GetLayoutObjectAttribute ( Timefield ; "content" )

 

But do you really need a calculation field for this? If this is for printing/display, you could simply merge the fields into a text object and apply the same formatting to the object as you have to the time field.

 

Edited May 11, 20205 yr by comment

Can you explain the first option a little? I don get what the serialIncrement does...

SerialIncrement ( ":00" ; Minute ( Timefield ) )

21 minutes ago, Yki said:

I don get what the serialIncrement does...

It formats the minutes with a ":" prefix and a leading zero. Read more:
https://fmhelp.filemaker.com/help/18/fmp/en/index.html#page/FMP_Help%2Fserialincrement.html%23

 

Interesting. Thank you.

And yes, "merge field" is good for me here:)