kvrogers
asked on
Crystal Reports_ Convert time to hh:mm AM or PM
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.
time(TRUNCATE({Assc99.T_Ap pt}/3600), ((REMAINDE R({Assc99. T_Appt},36 00))/60),0 )
How do I get rid of the SECONDS?
KR
It is printing like this 7:00:00AM. Here is the formula I'm using.
time(TRUNCATE({Assc99.T_Ap
How do I get rid of the SECONDS?
KR
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER