Quick question. I've got a column with elapsed time in the format 0:03 for 3 minutes, or 0:12 for 12 minutes. I used the formula =IFERROR(TEXT(F27-E27,"H:MM"),"") to get the elapsed time so there are several blank columns in between if there is no time data for a particular cell.

I need to calculate the average and standard deviation of the elapsed time.

thank you