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!

  • Congratulations strongm 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. MDJ2005

    Displaying excel times > 24 hours

    Thanks! That seems to fix the format. It appears that I'll need to divide all of the seconds by 86400 (60sec*60min*24hrs) to get the data into the portion of a day to make it work consistently. Ta, Matt
  2. MDJ2005

    Displaying excel times > 24 hours

    I'm working on an spreadsheet that presents call center rep data for a weekly period. Times are currently stored in seconds. I'd like the data to be displayed as hh:mm:ss but over a week many reps have more than 24 hours of call activity and so it is not displaying correctly. I can force the...
  3. MDJ2005

    Putting an average in the footer

    Man, that sure was easier than the other things I was trying! Thanks!
  4. MDJ2005

    Putting an average in the footer

    I've been able to put SUMs of columns into footers, but it isn't clear to me how I could put an average calculation into a footer (as in calculating an average wage for a department). Does anyone know how to best approach this? Thanks! -Matt
  5. MDJ2005

    If, Then derived field "Missing operands?"

    The book I have from ADP indicates that @IF is true if the test parameter is non-zero but then adds parenthetically (greater than or equal to 1). Does this mean a negative value would make the @IF statement false? I don't have a specific application, but can think of way that I would use this...
  6. MDJ2005

    Novice question for derived vars for v. 4.2.2

    The field is set up as TotHrs and the formula in the derived field creation dialog is currently REPORTS.V_CHK_VW_EARNINGS.CHECKVIEWOTHOURS + REPORTS.V_CHK_VW_EARNINGS.[[Reg_Hours]] Although all records have a Reg_Hours value, the TotHrs only displays a value if both fields have values.
  7. MDJ2005

    Novice question for derived vars for v. 4.2.2

    I'm a complete novice to reportsmith (change in HR staff!). I am trying to add three fields together and having a heck of a time. It is in the ADP database and the three fields (on the standard Hours report) are CHECKVIEWREGHOURS + CHECKVIEWOTHOURS + CHECKVIEWHOURSAMT. I'm using the derived...

Part and Inventory Search

Back
Top