HI,

I am sending out automatic confirmation emails to my clients, and I would like the email to say "your appointment on DATE from 10:30AM to 12PM". The start time is "Table::VisitTime", how do I add 1.5h to the visittime and display that value? I tried "Table::VisitTime+130" but then it returned 1160 instead of 12:00PM. Any ideas of how to get the calculation to equal 12pm would be greatly appreciated!

Thank you,

Esther

A time Value in FileMaker is internally stored as the number of seconds since Midnight.

If you add 3600 * 1.5, there are 3600 seconds to an hour, you will add the number of seconds equal to one and a half hours.