Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tsgsac

  1. tsgsac

    Convert Number to Time Field

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

    Convert Number to Time Field

    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 :=...
  3. tsgsac

    Convert Number to Time Field

    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...
  4. tsgsac

    Convert Number to Time Field

    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...
  5. tsgsac

    Convert Number to Time Field

    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...
  6. tsgsac

    Convert Number to Time Field

    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)))
  7. tsgsac

    Convert Number to Time Field

    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)))
  8. tsgsac

    Convert Number to Time Field

    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...
  9. tsgsac

    Convert Number to Time Field

    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...
See more

Part and Inventory Search

Back
Top