henry
asked on
crystal report convert integer time into format: HH:MM (AM PM)
Hello,
My field with integer value: systime
ex.
systime: 25448
How to convert into HH:MM format in crystal report ?
thanks
henry
My field with integer value: systime
ex.
systime: 25448
How to convert into HH:MM format in crystal report ?
thanks
henry
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If that's just the time of day -- So 25448 is 2:54:48 AM, and 231234 would be 11:12:34 PM, and the largest value would be 235959 (11:59:59 PM) -- then you could convert it to a time using
Time (Picture (CStr ({systime}, "000000"), "xx:xx:xx"))
Then you could format the time however you like.
If the number is actually a duration, how high can it go? If it can be over 24 hours, how do you want to show that?
James
Time (Picture (CStr ({systime}, "000000"), "xx:xx:xx"))
Then you could format the time however you like.
If the number is actually a duration, how high can it go? If it can be over 24 hours, how do you want to show that?
James
ASKER
Thanks,
Working good
Working good
mlmcc