Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How do calculate standard deviation of time values?

I have a set of time values, formatted as 02:43:00 AM, 03:55:00 AM, etc. When I pass the set of values into the STDEV() function, I get a decimal value 0.0937. How can I convert this into a usable time value, or am I going about this the wrong way entirely?

How do calculate standard deviation of time values?

I have a set of time values, formatted as 02:43:00 AM, 03:55:00 AM, etc. When I pass the set of values into the STDEV() function, I get a decimal value 0.0937. How can I convert this into a usable time value, or am I going about this the wrong way entirely?