calculate frequency of time

**mubashar** · 02-10-2014, 11:35 PM

in column E contains time values in format HH:MM:SS. i have following code but it gives error on rngtime value. Please suggest me to correct it.

Please Login or Register  to view this content.

**bsalv** · 02-11-2014, 01:16 AM

perhaps you mean this

Please Login or Register  to view this content.

**mubashar** · 02-11-2014, 09:38 AM

i like to use frequency method ... correct it using frequency method.

**bsalv** · 02-11-2014, 10:02 AM

??? frequency with 1 element as 2nd argument.
post a example with your range E2:E11 and the result you want to achieve.

Re: calculate frequency of time