# Solved How can this function be modified to do stats?

October 26, 2015 at 09:14:14
Specs: Windows 8
 Hi - I would like to do time statics for a set of data in a table so I can calculation mean, mode, etc. How can I easily strip the characters and still perform calculations?How about this then:=NETWORKDAYS((A3,B3,\$AA\$1:\$AA\$5)-1)&" Days "&HOUR(MOD(B3-A3,1))&" Hour "&MINUTE(MOD(B3-A3,1))&" Minutes"Simply subtract 1 from the =NETWORKDAYS() function.It will then show 0 Days XX Hours XX Minutes.MIKE See More: How can this function be modified to do stats?

#1 October 26, 2015 at 11:34:03
 Your going to have to explain, in a lot more detail, what it is your trying to do.Showing a formula, without context, does little to explain your problem.If all you want is the formula stripped of text then try this:=NETWORKDAYS((A3,B3,\$AA\$1:\$AA\$5)-1)&HOUR(MOD(B3-A3,1))&MINUTE(MOD(B3-A3,1))MIKEhttp://www.skeptic.com/

Report •

#2
October 26, 2015 at 13:21:34
 Mike - I have attempting to perform data collection where I track interval time between activities. I could not identify an Excel function using a time format that includes days and hours (I don't need accuracy to the minute) where I can determine means, modes, standard deviation, etc. for the data so I can compare current to future state. I am not a programmer but just want to use the time data for process improvement data points.Your formula does remove the characters but I don't know how I would use the result as with the mixed units (days and hours) even if I removed the minutes.Can you suggest a method to apply statistics functions using a time format?Note: For the formula to work, the first parenthesis has to be move to the left of Network Days:=(NETWORKDAYS(A3,B3,\$AA\$1:\$AA\$5)-1)&HOUR(MOD(B3-A3,1))&MINUTE(MOD(B3-A3,1))Any advice would be appreciated as I will need to about a 1000 records with about 7 time intervals between tasks. Thank you.Fred

Report •

#3 October 26, 2015 at 13:43:22 