When formatting a time field in a Crystal Report formula field you can use the ToText function that is built into Crystal Reports.
The basic formula is: ToText({fieldname}, "Time Format")
To build a time format, use "m" for minute, "s" for second and "t" for AM/PM. For hours you can choose to use "H" for a 24 hour format or "h" for a 12 hour format. They can be used in combination to build a large number of formats.
See examples below for a starting place:
"HH:mm:ss" = 13:08:05
"h:m t" = 1:8 P
"hh:mm tt" = 01:08 PM
Comments
0 comments
Please sign in to leave a comment.