Average & standard deviation of hh:mm:ss

  • I am trying to subtract two columns(A & B) with dd-mm-yyyy hh:ss format and get the values in column "C" as hh:mm:ss

    Finally i have to get the average and standard deviation for the Column "C", but i am getting error .

    Can anyone help how to subtract 2 columns and take average and stdev. I have attached my excel sheet for the reference


    • Excel.xlsx

      (87.04 kB, downloaded 55 times, last: )