I have a report where the field T_Appt (time of appointment) is actually a number like 2600. I would like this field to read like 07:15 AM or 1:00 PM.
It is printing like this 7:00:00AM. Here is the formula I'm using.
How do I get rid of the SECONDS?