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

    The hour is disappearing when reading a text file into crystal

    Hi, Thanks for the responses, I thought I was going mad in crystal not being able to convert it on the import, but looks like I'm going to have to use excel. Thanks again James
  2. thetoftee

    The hour is disappearing when reading a text file into crystal

    Thanks but unfortunatly that is the way the text file comes through :(
  3. thetoftee

    The hour is disappearing when reading a text file into crystal

    Hi, I'm reading a text file directly into crystal which looks like the following: Hr,0-4s,5-9s,10-14s,15-19s,20-24s,25-29s,30-44s,45-59s,60-89s,gt90 sec,max_ans_time 2013-06-26 04,10,0,0,0,0,0,0,0,0,0,0 2013-06-26 05,33,0,0,0,0,0,0,0,0,0,1 2013-06-26 06,58,0,0,0,0,0,0,0,0,0,3 The first column...
  4. thetoftee

    Average traffic over 4 time periods

    Hi thanks for the advice, but I need to be able to get an average across any 4 time periods for example the 4 15 minute time periods between 1300 1315 1330 1345 would be one average, then I need the average of 1315 1330 1345 1400 and so on I've tried grouping them by hour, but can't get the...
  5. thetoftee

    Average traffic over 4 time periods

    Hi, I have a set of data that is in quarter hourly granularity showing traffic for each 15 minute time period. I need to find the average traffic across 4 15 minute time periods and then from that find the busy hour. I having been looking at using running totals but haven't got a clue how to...

Part and Inventory Search

Back
Top