minutes and seconds

  1. M

    Entering minutes and seconds in excel

    I am creating a new KPI (Key Performance Indicator) dashboard for my company. One of the stats included is our ASA (Average Speed of Answer) and I'm trying to input the weekly numbers for each department and they have a MTD & YTD portion that will give us the overall average. The format of this...
  2. F

    function date

    Hi, how to get total time in minutes from date: <tbody> 18/11/2013 07:31:04 </tbody> Result shoud be: 451min (its 07*60 + 31).
  3. E

    hh:mm:ss and mm:ss computations

    Can someone assist me with computations on the following worksheet? http://tinypic.com/r/2qlv1c4/7 I need to do computations with times that may vary from hh:mm:ss and mm:ss. I have attached a photo of the spreadsheet. And I would like to do computations like this. I need to have all the...
  4. A

    Formula for calculating average time

    I am trying to calculate the average Talk Time into Minutes and Seconds. Every time I have tried, I get the wrong average. For example, if I have a total of 53 calls and the total talk time is 4:19:05, what would the average talk per call be? I tried doing everything in seconds (this would...

Some videos you may like

This Week's Hot Topics