I'm creating a script that will send an email to people that have an appointment.

In the email body I'm using a calculated result that pulls over the person's appointment

time. Could someone please share with me how I can format the time as text with the

appropriate AM or PM tag ??

I've searched for this but can't seem to find anything.

You may find better, but this works for me, result text:

Case (

TimeAppt = 43200;

Hour (TimeAppt) & ":" &

Right ( "00" & Minute(TimeAppt); 2) & " PM";

TimeAppt > 43200;

(Hour (TimeAppt) - 12) & ":" &

Right ( "00" & Minute(TimeAppt); 2) & " PM";

Hour (TimeAppt) & ":" &

Right ( "00" & Minute(TimeAppt); 2) & " AM"