Averaging Time

Results 1 to 2 of 2

Thread: Averaging Time

  1. #1
    Join Date
    Dec 1969

    Default Averaging Time

    I am generating a statistical database that logs all of the calls in my department detailing the length of the call. I am trying to find out a way to take values like :17, :59, 6:32, etc. and retrieve the average. The data is imported so I either have to do something with the current format or convert it to seconds. <BR><BR>My question is...<BR><BR>Is there something I can do with the format of min:sec or do I need to write a function to convert 1:30 to 90sec. and convert it back in the report?<BR><BR>-Thanks.

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Averaging Time

    I think you will have to convert it into seconds....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts