Search results for query: *

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

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

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

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

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

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.

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