Time format for Crystal Report

Question

how can i show only time in Crystal report my requirement is time format "hh:mm tt" but how it possible give me an idea working in vb.net crystal report

Answer 1

Right Click on the field >> Format Object >> Under Date and Time Tab >> Select the required Fromat and you can click on customize to re-format>> Under Date and Time Tab select from Order Mneu to show only Time >> and Under Time Tab select your Format 24 or 12 and to show hours, minutes and seconds

Answer 2

you can use CTime function to get the time value:

CTime(TimeIN)

http://www-01.ibm.com/support/knowledgecenter/SS4JCV_7.5.5/com.businessobjects.integration.eclipse.designer.doc/html/topic729.html%23id_2006123114004d2762e2_746