Time formula field (12/24 hour clock) 1

[StevenK]

I have a formula field {@FORMULA1} set up in a series of reports that results in a 'Time' type. This is in the 24-hour clock format. I want to create an additional formula field {@FORMULA2} so that I can have this same time printed in the 12-hour clock format (ie. 20:30:00 = 8:30:00 PM) - may need to have the result of this as a string. I'm guessing there's an easy way of doing this but I can't see it for looking.
Any ideas ?
Steve

 

[marckssg]

If you add the Formula1 field to your report twice and leave one on the 24 hour clock and then format the other so that its displayed in the 12 hour format.

This can be done by:
Right click on field, select Format Field, Customise, select the time tab and here you can select the 12 hout option.

Cheers

Marc

 

[kenhamady]

Post formula 1 and it will be easier to give you formula 2 Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[StevenK]

Thanks for the help Marc.
I'm now able to achieve what I need on the report.
Steve