formatting time as text with AM or PM in a calc ?

[Steven Cappiello]

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.

[Fenton]

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"