Calculating Standard Deviation +/- in one column

[Guest_imported]

Hi, I have two columns "DelWinFrom" and "DelWinTo" which is a time frame eg. between 05:00 and 05:30. I also have an "ActualTime" column and a "StandDev" column.

Can anybody please show me how I can calculate in the &quot;StandDev&quot; field if &quot;ActualTime&quot; < &quot;DelWinFrom&quot; then put a &quot;-&quot; in &quot;StandDev&quot; or if &quot;ActualTime&quot; > &quot;DelWinTo&quot; then put a &quot;+&quot; in &quot;StandDev&quot;, else just display blank in that section.

Also, if it's possible, would I also be able to add a Datediff function in there to display for e.g. -5 (minutes)

Thanks.

 

[JerryDennison]

Standard deviation cannot be calculated between two numbers. Did you want to know where the number fell in relation to Sigma for the entire population?

 

[Guest_imported]

i need to calculate it for each record

 

[JerryDennison]

What exactly are you trying to do?

Standard Deviation will always be zero between two numbers. You need more than two numbers to calculate Sigma. Statistically speaking, sigma isn't significant unless the sample size is large(i.e. 20 or more data points). So what do you want?