Standard deviation based on 2 criteria

[dolls]

Hi there,

I read a few other posts but had much difficulty modifying the formulas to match my needs.

I have two columns, one with different times (i.e. 1:07, 2:25, etc.) and another with a different values that range from 1-200. I already used the averageifs function to find the average for each of the time ranges (0:00-0:59, 1:00-1:59, etc) but need to find a formula to find the corresponding standard deviations.

Thank you in advance!

 

[joeu2004]

Nitpick....

TIME(1,0,0) and --"1:00" are the same thing. The double-negative (--) converts text to numeric.

I should say it "effectively converts text to numeric" or it has that effect "in this context".

The point is: the double negate (I shouldn't have said "double-negative") are simply arithmetic operations. Any arithmetic operation converts text time to numeric time. So there is no need to use double negate (--) in contexts where we are using some other arithmetic operations (e.g. subtraction).