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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.