Time Format Question

[metalteck]

I am currently using Crystal 10 and added a field that represents time. Only problem is that its formatted as a number field instead of a time field. How can I convert this over.

Now Want to have
Ex.
608 6:38:00 AM
1334 1:34:00 PM
1218 2:34:00 PM
2241 10:41:00 PM

Thank you

 

[synapsevampire]

I don't understand the formula used:

608 6:38:00 AM shouldn't it be 6:08
1334 1:34:00 PM
1218 2:34:00 PM shouldn't it be 12:18
2241 10:41:00 PM

Anyway, try a formula of:

stringvar MyTime := totext({table.timefield},0,"");
if len(MyTime) = 4 then
time(val(left(MyTime,2)), val(mid(MyTime,3)),0)
else
time(val(left(MyTime,1)), val(mid(MyTime,2)),0)

-k

 

[metalteck]

I'm sorry, you are right. Those were typo's.

One last question, if the field only has one digit, how would I get it represent in time field, in addition to the formula you gave me?

Ex. Actually
6 12:06 am
12 12:10 am
45 12:45 am

Thank you

 

[synapsevampire]

Try:

stringvar MyTime := totext({table.field},0,"");
if len(MyTime) = 4 then
time(val(left(MyTime,2)), val(mid(MyTime,3)),0)
else if len(MyTime) = 3 THEN
time(val(left(MyTime,1)), val(mid(MyTime,2)),0)
else if len(MyTime) <= 2 then
time(0, val(MyTime),0)

-k

 

[metalteck]

Thank you...your a big help as usual