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 Mike Lewis 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. NanaRod

    Time Divide

    I am not sure if I understand the question but the fields are for hours: minutes and Seconds, I do not want it to roll that into days. Example: Total Notes Time 4:56:33 Total Handle Time 123:53:44
  2. NanaRod

    Time Divide

    All the time fields are Date/Time, only calls answered is a number field. Thank you
  3. NanaRod

    Time Divide

    I used the following all the time fields. TreatmentTime: (24*Int(Sum([AgentEffectivenessRaw].[ACD_Treatment_Time]+[OACD_Treatment_Time]+[ACD_Email_Interaction_TIme]))+Format(Sum([AgentEffectivenessRaw].[ACD_Treatment_Time]+[OACD_Treatment_Time]+[ACD_Email_Interaction_TIme]),'h')) &...
  4. NanaRod

    Time Divide

    The data is imported from Excel and then an expression is used to get the total handle time. To sum the totals I had to change the format to h:nn:ss. That all works fine until I try to divide the totals in the report so that I can get the % of notes taken.
  5. NanaRod

    Time Divide

    Hello, I have created a report and in the report I wanted to calculate "total notes code time" by "total handle time" to get the % of notes code. The time has already been converted to h:nn:ss in the query. Below is the sample data, please help. Total Notes Time 4:56:33 Total Handle Time...

Part and Inventory Search

Back
Top