Search results for query: *

LB Thank you, your help was wonderful! Got just what I needed and opened the door to many possibilities.

lb Works, but displays grand total or all subtotals as well. I inserted it in the format editor of the summary. Is that were I should have done it? Formula entered: NumberVar dur := Sum ({@elapsed}); NumberVar hrs; NumberVar min; NumberVar sec; StringVar hhmmss; hrs :=...

LB Thank you, Thank you! After several days of studying your reply I finally got it. This is what I used: NumberVar dur:=datediff("s",datetime(date({dc_data.occ_date}),{@enroute time to time}),datetime(date({dc_data.inservice_date}),{@inservice time to time}));//get the seconds between 2...

LB, It would be confusing, The occ_date and inservice_date are date/time field however, the enroute_time_to_time and inservice_time_to_time are the fields that I created from the formula, those are time fields and what I need to get the elapsed time. The only reason I am looking at the...

LB, Thank you for your efforts concerning my crystal issue. I went back and reviewed the data and found that the calculations are correct and the data in the enroute field is displaying incorrect. With that said now I can move forward to calculate the difference between inservice time and...

The data is being shown in the Detail section of Crystal. I am providing all information associated with this formula and result data. formula: //change number to time: stringvar x :=totext({dc_data.enroute_time},"000000"); time(val(left(x,2)),val(mid(x,3,2)),val(right(x,2)))

Columns three is the data and fourn is the column in which the formula is used. Formula Utilized: //change number to time: stringvar x :=totext({dc_data.enroute_time},"000000"); time(val(left(x,2)),val(mid(x,3,2)),val(right(x,2)))

I have included sample page of my result, hope this helps. Thank you. occ_date case_type enroute_time enroute time to tim inservice_time 10/1/2008 120:0100:00AM 91902 9:28:14 am 93429 10/1/2008 120:0100:00AM 91902 9:19:02 am 121641 10/1/2008 120:0100:00AM 91902 9:19:08 am 102855 10/1/2008...

New Member: New Crystal UserI have a formula that converts number to a time field however, it is not converting consistently correct. Some of the data is correct, no pattern when correct data is provided. Example of data supplied: 91902 Should be 9:19:02AM 172352 Should be 5:23:52PM...