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!

Search results for query: *

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

Part and Inventory Search

Back
Top